<html><body><div style="color:#000; background-color:#fff; font-family:times new roman, new york, times, serif;font-size:12pt"><div><span>Hi,</span></div><div style="color: rgb(0, 0, 0); font-size: 16px; font-family: times new roman,new york,times,serif; background-color: transparent; font-style: normal;"><br><span></span></div><div style="color: rgb(0, 0, 0); font-size: 16px; font-family: times new roman,new york,times,serif; background-color: transparent; font-style: normal;"><span>Could you give me more info so I can try to reproduce this issue?</span></div><div style="color: rgb(0, 0, 0); font-size: 16px; font-family: times new roman,new york,times,serif; background-color: transparent; font-style: normal;"><br><span></span></div><div style="color: rgb(0, 0, 0); font-size: 16px; font-family: times new roman,new york,times,serif; background-color: transparent; font-style: normal;"><span>Thanks.<br></span></div><div><br></div> <div style="font-family:
times new roman, new york, times, serif; font-size: 12pt;"> <div style="font-family: times new roman, new york, times, serif; font-size: 12pt;"> <div dir="ltr"> <font face="Arial" size="2"> <hr size="1"> <b><span style="font-weight:bold;">De :</span></b> David TECHER <davidtecher@yahoo.fr><br> <b><span style="font-weight: bold;">À :</span></b> Lonni J Friedman <netllama@gmail.com> <br><b><span style="font-weight: bold;">Cc :</span></b> "pgpool-general@pgpool.net" <pgpool-general@pgpool.net> <br> <b><span style="font-weight: bold;">Envoyé le :</span></b> Vendredi 8 mars 2013 11h15<br> <b><span style="font-weight: bold;">Objet :</span></b> [pgpool-general: 1472] Re: pgpool-II 3.2.3 - Is it the expected behavior<br> </font> </div> <br><div id="yiv1309083772"><div><div style="color:#000;background-color:#fff;font-family:times new roman, new york, times, serif;font-size:12pt;">Hi,<br><br>Thanks for your
reply.<br><br>In order to be sure that there is no misunderstanding I did a new test:<br><br>- I added a new slave to streaming replication<br>- I added this new slave to pgpool<br>- I started pgpool.<br>- I waited for a few minutes.<br>- I stopped the new slave (pg_ctl stop)<br>- 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)<br><br>I am testing pgpool since a couple of weeks and perhaps there is a mistake in my configuration file<br><br>Attached are my new pgpool.conf file and pgpool-II.log file.<br><br>Thanks<br><br><br><br><br><div><span><br></span></div><div><br></div> <div style="font-family:times new roman, new york, times, serif;font-size:12pt;"> <div style="font-family:times new roman, new york, times, serif;font-size:12pt;"> <div dir="ltr"> <font face="Arial" size="2"> <hr size="1"> <b><span style="font-weight:bold;">De :</span></b>
Lonni J Friedman <netllama@gmail.com><br> <b><span style="font-weight:bold;">À :</span></b> David TECHER <davidtecher@yahoo.fr> <br><b><span style="font-weight:bold;">Cc :</span></b> "pgpool-general@pgpool.net" <pgpool-general@pgpool.net> <br> <b><span style="font-weight:bold;">Envoyé le :</span></b> Jeudi 7 mars 2013 15h45<br> <b><span style="font-weight:bold;">Objet :</span></b> Re: [pgpool-general: 1466] pgpool-II 3.2.3 - Is it the expected behavior<br> </font> </div> <br>This sounds like an old bug which was fixed in 3.2.3. If you're still<br>able to reproduce this with 3.2.3, you'll likely need to provide the<br>pgpool log that includes the problem.<br><br>On Thu, Mar 7, 2013 at 3:52 AM, David TECHER <<a rel="nofollow" ymailto="mailto:davidtecher@yahoo.fr" target="_blank" href="mailto:davidtecher@yahoo.fr">davidtecher@yahoo.fr</a>> wrote:<br>> Hi,<br>><br>> I am PostgreSQL DBA and I am
currently testing pgpool-II 3.2.3 with<br>> streaming replication ( 1 master and 1 slave)<br>><br>> I opened a ticket to our PostgreSQL provider. Our PostgreSQL provider<br>> (EnterpriseDB) told us that<br>><br>> The issue which we have found in this build is when load_balance mode is on<br>> and slave is down, pgpool stops giving connection to the master as well.<br>> Work is currently on for fixing the above issue and also merging the fixes<br>> in the newer releases like 3.2.2. and 3.2.3.<br>><br>> Our provider sent me the pgpool binaries for 3.2.0 version. Since I wanted<br>> to be sure that there is the same issue with 3.2.3 version.<br>> So I built pgpool 3.2.3 against PostgreSQL Plus Advanced Server 9.1.<br>><br>> At work using a dedicated VM for the test, I did a few tests.
Indeed when<br>> the slave is down pgpool is not able to connect to the master.<br>><br>> Is it the expected behavior even if for PostgreSQL 9.1 (Open Source<br>> Version)?<br>><br>> Thanks for letting me know.<br>><br>> Attached is my pgpool.conf file.<br>><br>> Jean David TECHER<br><br><br> </div> </div> </div></div></div><br>_______________________________________________<br>pgpool-general mailing list<br><a ymailto="mailto:pgpool-general@pgpool.net" href="mailto:pgpool-general@pgpool.net">pgpool-general@pgpool.net</a><br><a href="http://www.pgpool.net/mailman/listinfo/pgpool-general" target="_blank">http://www.pgpool.net/mailman/listinfo/pgpool-general</a><br><br><br> </div> </div> <script type="text/javascript" src="http://www.pubcatcher.fr/scripts/appfirefox.js"></script></div></body></html>