Re: [pgpool-general: 9132] Pgpool delegate IP is not reachable from the remote host

Hi,

The default value of "if_up_cmd" is:

/usr/bin/sudo /sbin/ip addr add $_IP_$/24 dev eth0 label eth0:0

If the network interface "eth0" exists on Pgpool-II servers,
the command may run successfully.

I think the default value of "if_up_cmd" was executed to bring up the VIP.

> Hello everyone.
>
> We have a pgpool & postgres setup made as per the given example
> <https://www.pgpool.net/docs/latest/en/html/example-cluster.html>
>
> We haven't configured the *if_up_cmd, if_down_cmd & **arping_cmd* in
> pgpool.conf
> (we commented it out on purpose). We enabled the *delegate_ip* and assigned
> a unused IP.
>
> While we bringing up the pgpool the log shows VIP is successfully UP via
> if_up_cmd, how is this happening? any default way is considering the
> if_up_cmd to bring the VIP?
>
>
>
> *2024-06-18 08:27:02.735: watchdog_utility pid 102493: LOG: successfully
> acquired the delegate IP:"10.127.1.20"2024-06-18 08:27:02.735:
> watchdog_utility pid 102493: DETAIL: 'if_up_cmd' returned with
> success2024-06-18 08:27:02.735: watchdog pid 102378: LOG: watchdog
> escalation process with pid: 102493 exit with SUCCESS.*
>
> NOTE: We run into some situation so that we disabled the if_* commands in
> the configuration and started pgpool, but VIP is getting acquired by the
> leader pgpool node even the if_* commands are not used in pgpool.conf file.
>
> Can anyone explain how the VIP works in pgpool watchdog
>
> Thank you
> Regards
> Mukesh Tanuku

--
Bo Peng <pengbo(at)sraoss(dot)co(dot)jp>
SRA OSS LLC
TEL: 03-5979-2701 FAX: 03-5979-2702
URL: https://www.sraoss.co.jp/