[pgpool-general: 8656] Re: Failover doesn't promote standby server to new one (PgPool-II 4.1.3 PostGres 13)

Bo Peng pengbo at sraoss.co.jp
Mon Mar 20 20:31:16 JST 2023


Hello,

> i've configured the cluster following the guide https://www.pgpool.net/docs/41/en/html/example-cluster.html, so I obtain the situation with one primary and two standby.
> 
>   *   When I switch off pgpool service on primary e new pgpool is elected ad master and is ok
>   *   When I switch off postgres, failover.sh is launched, a new postgres is promoted as primary but in show_pgpool_nodes the up nodes are all in standby mode. If I restart postgres service and pgpool service, on the elected standby it appears as new primary but no streaming with the others.
> 
> What I have to check?

Please check the pgpool.log if failover.sh succeeded and
after running failover.sh if pgpool was able to detect the new primary.

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



More information about the pgpool-general mailing list