Re: pcp_promote_node and watchdog

Hi,

pcp_promote_node --switchover does not change the watchdog status and does not move the watchdog virtual IP. This is expected behavior.
pcp_promote_node only switches PostgreSQL backend roles between primary and standby.

In Pgpool-II, the VIP is associated with the Pgpool-II leader, not with the PostgreSQL primary. Therefore, even if you perform a PostgreSQL switchover using pcp_promote_node commands, it is not possible to make the VIP to migrate to the promoted primary.

Best regards,

Taiki Koshino<koshino(at)sraoss(dot)co(dot)jp>
SRA OSS K.K.
TEL: 03-5979-2701 FAX: 03-5979-2702
URL: https://www.sraoss.co.jp/

________________________________
差出人: Luca Ferrari <fluca1978(at)gmail(dot)com>
送信日r: 2025年12月18日 2:14
宛先: pgpool-general(at)lists(dot)postgresql(dot)org <pgpool-general(at)lists(dot)postgresql(dot)org>
件名: pcp_promote_node and watchdog

Hi all,
I don't understand if using pcp_promote_node --switchover
(<https://www.pgpool.net/docs/47/en/html/pcp-promote-node.html>)
implies also a watchdog status change, as it seems to me this is not
the case. Assuming I have a current pimrary and main node, and I want
to promote another node in the cluster, what is the correct way to
make the watchdog ip to migrate to the promoted primary?

Thanks,
Luca