[pgpool-general: 8698] Re: Host where failover script is executed

Bo Peng pengbo at sraoss.co.jp
Thu Mar 30 13:21:58 JST 2023


Hello,

> I've seen that in failover script example the promote command is executed
> in new primary host via ssh.
> 
> However, in my environment ssh is not needed because failover is executed
> in the new primary host. Is this the expected behaviour?

Yes.

Just in this case, pgpool leader and new PostgreSQL primary are on same server.
However, pgpool leader may change when leader goes down.
And if the new primary goes down, other standby will be elected as new primary.

> My environment is pgpool 4.3.2 with 2 nodes running postgres 11 and pgpool
> with watchdog enabled.
> 
> Thanks in advance.
> 
> Best,
> Jesús


-- 
Bo Peng <pengbo at sraoss.co.jp>
SRA OSS LLC
https://www.sraoss.co.jp/



More information about the pgpool-general mailing list