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

Ron ronljohnsonjr at gmail.com
Tue Feb 7 23:55:30 JST 2023


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.



More information about the pgpool-general mailing list