[pgpool-general: 8357] Separate backend(!) network?
tony.albers at gmx.com
Thu Aug 18 21:19:12 JST 2022
Would it be possible to set up 3 postgresql nodes running pgpool-II so that:
We have two networks:
A, a frontend network(192.168.100.0/24), where clients connect to pgpool-II on port 9999 and get the postgresql service, but nothing else is available on that network.
B, a 'heartbeat' network(192.168.110.0/24), where we do watchdog, pcp, heartbeat and failover.
Could this be done? I thought so, but I seem to have misunderstood the term 'backend_network' in the docs, which seem to refer to postgresql servers _behind_ a pgpool2 cluster, and not a dedicated failover/heartbeat network.
So what I've done is I have 3 nodes, each running PostgreSQL and Pgpool-II, with networks and hostnames like this:
And I'd like clients to connect to the VIP, and heartbeat, watchdog etc. to use the .back hostnames/network.
Any suggestions are much appreciated.
Tony Albers <tony.albers at gmx.com>
More information about the pgpool-general