Re: Postresql HA 2 nodes - Mailing list pgsql-general

From Jehan-Guillaume de Rorthais
Subject Re: Postresql HA 2 nodes
Date
Msg-id 20230517142225.05f5b8ea@karst
Whole thread Raw
In response to Postresql HA 2 nodes  (Marcello Lorenzi <cello86@gmail.com>)
List pgsql-general
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,



pgsql-general by date:

Previous
From: Evgeny Morozov
Date:
Subject: Re: "PANIC: could not open critical system index 2662" - twice
Next
From: Tom Lane
Date:
Subject: Re: Postgres Incompatibility