Обсуждение: Pgpool delegate IP is not reachable from the remote host
Hello everyone.
We have a pgpool & postgres setup made as per the given example
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 success
2024-06-18 08:27:02.735: watchdog pid 102378: LOG: watchdog escalation process with pid: 102493 exit with SUCCESS.
2024-06-18 08:27:02.735: watchdog_utility pid 102493: DETAIL: 'if_up_cmd' returned with success
2024-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
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@sraoss.co.jp> SRA OSS LLC TEL: 03-5979-2701 FAX: 03-5979-2702 URL: https://www.sraoss.co.jp/