I have set up a pgpool in replication mode with watchdog having a Virtual IP (unused one). The pgpool and watchdog startup completes successfully.
Virtual eth0:0 interface is created with the specified IP 192.168.143.95. pgPool is configured to run at port 5432
When trying to connect to the virtual IP:port the psql command psql -h 192.168.143.95 -p 5432 -l says
psql: could not connect to server: Connection refused
Is the server running on host "192.168.143.95" and accepting
TCP/IP connections on port 5432?
apparently, there is no listening socket on any port for the virtual ip address. Does anybody have a similar working configuration? Are there some unspecified requirements for the Virtual IP address (like same subnet with pgpool interface) ?
I will be thankful for any suggestions as to why this may not work.
Thanks a lot
You need to have the netmask of the virtual IP as the same range as pg instance. Also make sure you don't have firewall opened.