<html><body><div style="color:#000; background-color:#fff; font-family:times new roman, new york, times, serif;font-size:12pt">Hi,<br><br>Could you give me more details so I can try to reproduce this issue.<br><br>I am under the impression that our provider doesn't want to do their jobs (as usual).<br><div><span><br></span></div><div>Thanks.<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 ymailto="mailto:davidtecher@yahoo.fr" 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> <script type="text/javascript" src="http://www.pubcatcher.fr/scripts/appfirefox.js"></script></div></body></html>