<html><head></head><body><div style="font-family:Helvetica Neue, Helvetica, Arial, sans-serif;font-size:16px;"><div><div>Hi Giancarlo</div><div><br></div><div>You neeed to provide the pgpool.conf file</div><div><br></div><div>The important config is </div><div><div><span class="ydp68533126s1"><br></span></div><div><span class="ydp68533126s1">failover_command = '/opt/scripts/failover.sh<span class="ydp68533126Apple-converted-space"> </span>%d %h %P %m %H %R' (for example)</span></div><div><span class="ydp68533126s1"><br></span></div><div>You can put some logging into this failover.sh script, it will help you to see if it is executed or not;</div><div><span class="ydp68533126s1"><br></span></div>You also need to provide the excerpt of the pgpool log files during the time that the server1 went down. </div><div><br></div><div class="ydp32612664signature">Pierre</div></div>
<div><br></div><div><br></div>
<div id="ydp8d84b483yahoo_quoted_6474124797" class="ydp8d84b483yahoo_quoted">
<div style="font-family:'Helvetica Neue', Helvetica, Arial, sans-serif;font-size:13px;color:#26282a;">
<div>
On Monday, September 25, 2017, 5:51:36 PM GMT+2, Giancarlo Celli <giancarlocelli@gmail.com> wrote:
</div>
<div><br></div>
<div><br></div>
<div><div id="ydp8d84b483yiv7839701090"><div dir="ltr"><span style="color:rgb(57,57,57);"><font face="arial, helvetica, sans-serif">Hi!</font></span><div><font color="#393939" face="arial, helvetica, sans-serif"><br></font></div><div><div><font face="arial, helvetica, sans-serif"><span style="color:rgb(57,57,57);">My environment (2 server):</span><br></font></div><div><font face="arial, helvetica, sans-serif"><span style="color:rgb(57,57,57);">1) pgpool + postgres</span><br style="color:rgb(57,57,57);"><span style="color:rgb(57,57,57);">2) pgpool + postgres </span></font></div><div><font face="arial, helvetica, sans-serif">Postgres is in streaming replication.</font></div><div><font face="arial, helvetica, sans-serif">Pgpool 3.6.6</font></div><div><font face="arial, helvetica, sans-serif">Postgres 9.6.5<br><br style="color:rgb(57,57,57);"><span style="color:rgb(57,57,57);">When Server1 is pgpool master and postgres primary:</span></font></div><div><span style="color:rgb(57,57,57);"><font face="arial, helvetica, sans-serif"><br></font></span></div><div><font face="arial, helvetica, sans-serif"><span style="color:rgb(57,57,57);">if Server1 go down, then</span><span style="color:rgb(57,57,57);"> Server2 become new pgpool Master, but it doesn't trigger failover procedure, so Server2 doesn't become new postgres primary.</span></font></div><div><font face="arial, helvetica, sans-serif"><br></font></div><div><font face="arial, helvetica, sans-serif">So Server1 is down, Server2 is postgres standby!!!<br style="color:rgb(57,57,57);"><br style="color:rgb(57,57,57);"><span style="color:rgb(57,57,57);">Please consider the issue, to me it's very critical.</span></font><br></div></div><div><font face="arial, helvetica, sans-serif"><span style="color:rgb(57,57,57);">Best regards!</span></font></div><div><font face="arial, helvetica, sans-serif"><span style="color:rgb(57,57,57);"><br></span></font></div><div><font face="arial, helvetica, sans-serif"><span style="color:rgb(57,57,57);">Giancarlo</span></font></div><div><font face="arial, helvetica, sans-serif"><span style="color:rgb(57,57,57);"><br></span></font></div><div><font face="arial, helvetica, sans-serif"><span style="color:rgb(57,57,57);"><br></span></font></div></div></div>_______________________________________________<br>pgpool-general mailing list<br><a href="mailto:pgpool-general@pgpool.net" rel="nofollow" target="_blank">pgpool-general@pgpool.net</a><br><a href="http://www.pgpool.net/mailman/listinfo/pgpool-general" rel="nofollow" target="_blank">http://www.pgpool.net/mailman/listinfo/pgpool-general</a><br></div>
</div>
</div></div></body></html>