[pgpool-general: 1472] Re: pgpool-II 3.2.3 - Is it the expected behavior

David TECHER davidtecher at yahoo.fr
Fri Mar 8 19:15:37 JST 2013


Thanks for your reply.

In order to be sure that there is no misunderstanding  I did a new test:

- I added a new slave to streaming replication
- I added this new slave to pgpool
- I started pgpool.
- I waited for a few minutes.
- I stopped the new slave (pg_ctl stop)
- I tried to connect using pgpool but it didn't work. (pgpool didn"t allow any connection  for the master and not the the first slave)

I am testing pgpool since a couple of weeks and perhaps there is  a mistake in my configuration file

Attached are my new pgpool.conf file and pgpool-II.log file.


 De : Lonni J Friedman <netllama at gmail.com>
À : David TECHER <davidtecher at yahoo.fr> 
Cc : "pgpool-general at pgpool.net" <pgpool-general at pgpool.net> 
Envoyé le : Jeudi 7 mars 2013 15h45
Objet : Re: [pgpool-general: 1466] pgpool-II 3.2.3 - Is it the expected behavior
This sounds like an old bug which was fixed in 3.2.3.  If you're still
able to reproduce this with 3.2.3, you'll likely need to provide the
pgpool log that includes the problem.

On Thu, Mar 7, 2013 at 3:52 AM, David TECHER <davidtecher at yahoo.fr> wrote:
> Hi,
> I am PostgreSQL DBA and I am currently testing pgpool-II 3.2.3 with
> streaming replication ( 1 master and 1 slave)
> I opened a ticket to our PostgreSQL provider. Our PostgreSQL provider
> (EnterpriseDB) told us that
> The issue which we have found in this build is when load_balance mode is on
> and slave is down, pgpool stops giving connection to the master as well.
> Work is currently on for fixing the above issue and also merging the fixes
> in the newer releases like 3.2.2. and 3.2.3.
> Our provider sent me the pgpool binaries for 3.2.0 version. Since I wanted
> to be sure that there is the same issue with 3.2.3 version.
> So I built pgpool 3.2.3 against PostgreSQL Plus Advanced Server 9.1.
> At work using a dedicated VM for the test, I did a few tests. Indeed when
> the slave is down pgpool is not able to connect to the master.
> Is it the expected behavior even if for PostgreSQL 9.1 (Open Source
> Version)?
> Thanks for letting me know.
> Attached is my  pgpool.conf file.
> Jean David TECHER
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20130308/7b19909f/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: pgpool.conf
Type: application/octet-stream
Size: 25073 bytes
Desc: not available
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20130308/7b19909f/attachment-0002.obj>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: pgpool-II.log
Type: application/octet-stream
Size: 40484 bytes
Desc: not available
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20130308/7b19909f/attachment-0003.obj>

More information about the pgpool-general mailing list