[pgpool-general: 8816] Re: Sync Virtual IP with database 'primary'

Tatsuo Ishii ishii at sraoss.co.jp
Tue Jun 6 17:11:32 JST 2023


> Hi
> 
> I want to attach the database VIP/delegateIP always to the database
> 'primary' node.
> Currently the way I try to achieve this is by bringing up the VIP
> inside the *failover.sh* script. During failover, It also removes the VIP
> from the old 'primary' node.
> 
> However, I do have a problem with the case when the old 'primary' is
> blacked out. (Not reachable anymore)
> It will still have the IP assigned and when it comes back to the network we
> have a problem.
> 
> Do you have any suggestions or thoughts on how to achieve this?
> (i.e Having the VIP on database *primary*?)

Unfortunately Pgpool-II does not have such a feature.

Best reagards,
--
Tatsuo Ishii
SRA OSS LLC
English: http://www.sraoss.co.jp/index_en/
Japanese:http://www.sraoss.co.jp


More information about the pgpool-general mailing list