Re: Postresql HA 2 nodes

On Tue, 16 May 2023 23:30:42 +0200
Marcello Lorenzi <cello86@gmail.com> wrote:

> Hi everyone,
> we're looking for the best solution for a 2-nodes cluster in HA with
> Postegresql 15. after some checks we are noticed about pgpool for the
> management of balancing and automatic failover. Can it be considered a
> viable and manageable solution for production?

Have a look at this recent discussion which discuss various solutions,
pros and cons:


https://www.postgresql.org/message-id/flat/AM9P251MB033074BFEBB9AA40955B5B7598929%40AM9P251MB0330.EURP251.PROD.OUTLOOK.COM

Regard,