[pgpool-hackers: 4154] Re: pgpool-II not listening on virtual IP..

[Bo Peng]

Hello,

> I'm very new at using pgpool-II, so please bear with me here.
> 
> I've set up a 3 node cluster, on Ubuntu 20.04(that's what they use
> where I work right now) based on the instructions here:
> https://www.pgpool.net/docs/latest/en/html/example-cluster.html
> 
> However, I've used an ansible collection for a lot of it, and it might
> be why it's not working properly.
> 
> If I look at the host that has the virtual IP, and do ss -anp |grep
> 9999 I get lines:
> 
> u_str   LISTEN   0        4096  /var/run/postgresql/.s.PGSQL.9999 40537
> * 0  users:(("pgpool",pid=12900,fd=5),("pgpool",pid=12899,fd=5),....
> 
> tcp     LISTEN   0        2000  0.0.0.0:9999   0.0.0.0:*
> users:(("pgpool",pid=12900,fd=6),...
> 
> But nothing on 192.168.122.100 which is the virtual IP:

You can see "0.0.0.0:9999" in the result.
"0.0.0.0:9999" means all IPv4 addresses.

> 3: enp9s0: <BROADCAST,MULTICAST,UP,LOWER_UP> mtu 1500 qdisc fq_codel
> state UP group default qlen 1000 link/ether 52:54:00:02:ee:63 brd
> ff:ff:ff:ff:ff:ff inet 192.168.122.102/24 brd 192.168.122.255 scope
> global enp9s0 valid_lft forever preferred_lft forever
>     inet 192.168.122.100/24 scope global secondary enp9s0:0
>        valid_lft forever preferred_lft forever
> 
> In pgpool.conf I have:
> listen_addresses = '*'
> port = 9999
> 
> And in /etc/postgresql/12/main/postgresql.conf:
> listen_addresses = '*'
> port = 5432
> 
> And in /var/lib/postgresql/12/main/postgresql.conf
> listen_addresses = '*'
> port = 5432
> 
> 
> 
> Any ideas?
> 
> Thanks in advance.
> 
> /tony
> _______________________________________________
> pgpool-hackers mailing list
> pgpool-hackers at pgpool.net
> http://www.pgpool.net/mailman/listinfo/pgpool-hackers


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