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

Ron ronljohnsonjr at gmail.com
Sun Feb 12 02:09:02 JST 2023


On 2/9/23 19:54, Bo Peng wrote:
> 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

This is what I needed.  Thank you.

-- 
Born in Arizona, moved to Babylonia.



More information about the pgpool-general mailing list