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

[Tony Albers]

Hi guys,

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:

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