[pgpool-general: 8597] Re: PgPool on 3 servers, Postgresql on 2 of them

[Bo Peng]

Hi,

> Postgresql is on Nodes A and B.  The VIP points to Node A.
> 
> How do I get the VIP to point to Node C?

So far Pgpool-II doesn't have such a feature to switchover VIP (Leader node) without restarting Pgpool-II.

If you wish to point VIP to Node C at startup, you can specify "wd_priority" parameter,
for example:

wd_priority = 1 (Node A)
wd_priority = 1 (Node B)
wd_priority = 2 (Node C)

Doc:
https://www.pgpool.net/docs/latest/en/html/runtime-watchdog-config.html#GUC-WD-PRIORITY

On Tue, 7 Feb 2023 08:55:30 -0600
Ron <ronljohnsonjr at gmail.com> wrote:

> 
> Postgresql is on Nodes A and B.  The VIP points to Node A.
> 
> How do I get the VIP to point to Node C?
> 
> (Postgresql is using streaming replication, if that matters.)
> 
> $ pcp_watchdog_info  -U postgres -v
> Password:
> Watchdog Cluster Information
> Total Nodes              : 3
> Remote Nodes             : 2
> Member Remote Nodes      : 2
> Alive Remote Nodes       : 2
> Nodes required for quorum: 2
> Quorum state             : QUORUM EXIST
> Local node escalation    : NO
> Leader Node Name         : NODEa:9999 Linux NODEa
> Leader Host Name         : NODEa
> 
> Watchdog Node Information
> Node Name         : FISPCCPGS405b:9999 Linux NODEb
> Host Name         : NODEb
> Delegate IP       : 10.143.170.42
> Pgpool port       : 9999
> Watchdog port     : 9000
> Node priority     : 1
> Status            : 7
> Status Name       : STANDBY
> Membership Status : MEMBER
> 
> Node Name         : NODEa:9999 Linux NODEa
> Host Name         : NODEa
> Delegate IP       : 10.1.1.42
> Pgpool port       : 9999
> Watchdog port     : 9000
> Node priority     : 1
> Status            : 4
> Status Name       : LEADER
> Membership Status : MEMBER
> 
> Node Name         : NODEc:9999 Linux NODEc
> Host Name         : NODEc
> Delegate IP       : 10.1.1.42
> Pgpool port       : 9999
> Watchdog port     : 9000
> Node priority     : 1
> Status            : 7
> Status Name       : STANDBY
> Membership Status : MEMBER
> 
> 
> -- 
> Born in Arizona, moved to Babylonia.
> _______________________________________________
> pgpool-general mailing list
> pgpool-general at pgpool.net
> http://www.pgpool.net/mailman/listinfo/pgpool-general


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