[pgpool-hackers: 4186] Re: Separate heartbeat network?

[Tony Albers]

Sorry for spamming the 'hackers' list, I'll post on the 'general' list instead.

/tony



On Thu, 18 Aug 2022 14:02:42 +0200
Tony Albers <tony.albers at gmx.com> wrote:

> Hi guys,
>
> 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:
> adbtopo01.front  192.168.100.143
> adbtopo01.back   192.168.110.143
>
> adbtopo02.front  192.168.100.162
> adbtopo02.back   192.168.110.162
>
> adbtopo03.front  192.168.100.197
> adbtopo03.back   192.168.110.197
>
> VIP              192.168.100.100
>
> 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.
>
>
> Thanks,
>
> /tony
>
>
> --
> Tony Albers <tony.albers at gmx.com>
> _______________________________________________
> pgpool-hackers mailing list
> pgpool-hackers at pgpool.net
> http://www.pgpool.net/mailman/listinfo/pgpool-hackers


--
Tony Albers <tony.albers at gmx.com>