[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