Pgpool delegate IP is not reachable from the remote host

Started by Mukesh Tanukualmost 2 years ago2 messagesgeneral
Jump to latest
#1Mukesh Tanuku
mukesh.postgres@gmail.com

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&gt;

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

#2Bo Peng
pengbo@sraoss.co.jp
In reply to: Mukesh Tanuku (#1)
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&gt;

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/