[pgpool-general: 5751] Re: When pgpool-postgres master down -> pgpool slave not promote postgres to primary, not trigger!

Pierre Timmermans ptim007 at yahoo.com
Tue Sep 26 02:31:40 JST 2017

Hi Giancarlo
You neeed to provide the pgpool.conf file
The important config is 
failover_command = '/opt/scripts/failover.sh  %d %h %P %m %H %R' (for example)
You can put some logging into this failover.sh script, it will help you to see if it is executed or not;
You also need to provide the excerpt of the pgpool log files during the time that the server1 went down. 

    On Monday, September 25, 2017, 5:51:36 PM GMT+2, Giancarlo Celli <giancarlocelli at gmail.com> wrote:  
My environment (2 server):
1) pgpool + postgres
2) pgpool + postgres Postgres is in streaming replication.Pgpool 3.6.6Postgres 9.6.5

When Server1 is pgpool master and postgres primary:
if Server1 go down, then Server2 become new pgpool Master, but it doesn't trigger failover procedure, so Server2 doesn't become new postgres primary.
So Server1 is down, Server2 is postgres standby!!!

Please consider the issue, to me it's very critical.
Best regards!

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/20170925/8d2e81fc/attachment.html>

More information about the pgpool-general mailing list