<div dir="ltr"><div><div>hi all,<br></div>I am trying to setup watchdog for my 2 nodes cluster (primary - standby, and will add another node later).<br></div><div>After i configure everything on my primary node (while pgpool on the other servers are down), I see the following in the syslog:<br>
<br>Jan 20 16:15:30 se032c-94-30 pgpool[29047]: wd_chk_sticky: ifup[/sbin/ip] doesn't have sticky bit<br>Jan 20 16:15:30 se032c-94-30 pgpool[29048]: watchdog: wd_check_config failed<br>Jan 20 16:15:30 se032c-94-30 pgpool[29048]: wd_main error<br>
Jan 20 16:15:30 se032c-94-30 pgpool[29048]: unlink(/tmp/.s.PGSQL.9898) failed: No such file or directory<br><br></div><div>I google a bit, looks like sticky bit is not set to /sbin folder by default, should i make change to system folder? why it's matter with pgpool?<br>
<br></div><div>here is my watchdog setting in pgpool.conf<br><br>#------------------------------------------------------------------------------<br># WATCHDOG<br>#------------------------------------------------------------------------------<br>
use_watchdog = on<br>trusted_servers = '10.89.94.31'<br>delegate_IP = '10.89.94.13'<br>wd_hostname = 'se032c-94-30'<br>wd_port = 9000<br>wd_interval = 10<br>ping_path = '/bin'<br>ifconfig_path = '/sbin'<br>
<br>if_up_cmd = 'ip addr add $_IP_$/32 dev eth0' < -- instead of using ifup and ifdown, i use the ip addr to bring up the virtual IP. I tried the eth0:0 but it did not work for me, but the ip addr add/del works just fine<br>
<br>if_down_cmd = 'ip addr del $_IP_$/32 dev eth0'<br>arping_path = '/sbin' # arping command path<br>arping_cmd = 'arping -U $_IP_$ -w 1'<br>wd_life_point = 3<br>wd_lifecheck_query = 'SELECT 1'<br>
#other_pgpool_hostname0 = 'host0'<br>#other_pgpool_port0 = 5432<br>#other_wd_port0 = 9000<br><br></div><div>Can someone give me some help here?<br><br>Thanks~<br>Ning<br></div></div>