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

Bo Peng pengbo at sraoss.co.jp
Mon May 11 14:59:42 JST 2020


Hello,

On Thu, 7 May 2020 18:10:20 +0000
Wolf Schwurack <wolf at uen.org> wrote:

> 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"

Pgpool-II watchdog doesn't support for IPv6.
It is not pgpool's issue.
You need to check your network setting.

> 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>
> 


-- 
Bo Peng <pengbo at sraoss.co.jp>
SRA OSS, Inc. Japan


More information about the pgpool-general mailing list