[pgpool-general: 7011] Pgpool-II-4.1.1 and Ubuntu 20.04

[Wolf Schwurack]

I have setup some new Ubunut 20.04 hosts with Pgpool-II-4.1.1 using  watchdog but unable to get watchdog to work on Ubuntu 20.04


2020-05-07 11:50:11: pid 7727: LOG:  Setting up socket for :::9999

2020-05-07 11:50:11: pid 7727: LOG:  perhaps failed to create INET domain socket

2020-05-07 11:50:11: pid 7727: DETAIL:  socket(::) failed: "Address family not supported by protocol"

2020-05-07 11:50:11: pid 7727: LOG:  find_primary_node_repeatedly: waiting for finding a primary node

2020-05-07 11:50:11: pid 7727: LOG:  find_primary_node: primary node is 0

2020-05-07 11:50:11: pid 7727: LOG:  find_primary_node: standby node is 1

2020-05-07 11:50:11: pid 7727: LOG:  pgpool-II successfully started. version 4.1.1 (karasukiboshi)
…

2020-05-07 11:50:23: pid 7731: LOG:  Watchdog is shutting down

I check for the IP with # ip a – No watchdog started


2: ens160: <BROADCAST,MULTICAST,UP,LOWER_UP> mtu 1500 qdisc fq_codel state UP group default qlen 1000

    link/ether 00:50:56:b3:d3:58 brd ff:ff:ff:ff:ff:ff

    inet 10.11.0.205/24 brd 10.11.0.255 scope global ens160

       valid_lft forever preferred_lft forever

To start the secondary IP from the command line I can use

ip addr add 10.11.0.204/24 dev ens160 label ens160:1

if I put this command in pgpool.conf it doesn’t start watchdog

But If I run the command from the command line, It creates the secondary IP for watchdog

2: ens160: <BROADCAST,MULTICAST,UP,LOWER_UP> mtu 1500 qdisc fq_codel state UP group default qlen 1000

    link/ether 00:50:56:b3:d3:58 brd ff:ff:ff:ff:ff:ff

    inet 10.11.0.205/24 brd 10.11.0.255 scope global ens160

       valid_lft forever preferred_lft forever

    inet 10.11.0.204/24 scope global secondary ens160:1

I comment out if_up_cmd and and if_down_cmd in pgpool.conf

Then I start pgpool, still get this in pgpool.log

2020-05-07 12:02:12: pid 8130: LOG:  perhaps failed to create INET domain socket

2020-05-07 12:02:12: pid 8130: DETAIL:  socket(::) failed: "Address family not supported by protocol"
but no message that watchdog is down

Then I test the connection, it work

$ psql -h wd-pgtest -p 9999 -U postgres

psql (12.2 (Ubuntu 12.2-4))

Type "help" for help.



postgres=#

My question is why can’t I get the command to work in pgpool.conf?

Wolfgang Schwurack
Database/System Administrator
Utah Education Network
801-587-9444
wolf at uen.org<mailto:wolf at uen.org>

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.pgpool.net/pipermail/pgpool-general/attachments/20200507/f8b9631a/attachment.htm>