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

David TECHER davidtecher at yahoo.fr
Sun Mar 10 20:41:59 JST 2013


Could you give me more info so I can try to reproduce this issue?


 De : David TECHER <davidtecher at yahoo.fr>
À : Lonni J Friedman <netllama at gmail.com> 
Cc : "pgpool-general at pgpool.net" <pgpool-general at pgpool.net> 
Envoyé le : Vendredi 8 mars 2013 11h15
Objet : [pgpool-general: 1472] Re: pgpool-II 3.2.3 - Is it the expected behavior


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

pgpool-general mailing list
pgpool-general at pgpool.net
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20130310/28558d79/attachment.html>

More information about the pgpool-general mailing list