Re: Postresql HA 2 nodes

From: Jehan-Guillaume de Rorthais <jgdr(at)dalibo(dot)com>
To: Marcello Lorenzi <cello86(at)gmail(dot)com>
Cc: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Postresql HA 2 nodes
Date: 2023-05-17 12:22:25
Message-ID: 20230517142225.05f5b8ea@karst
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tue, 16 May 2023 23:30:42 +0200
Marcello Lorenzi <cello86(at)gmail(dot)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,

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2023-05-17 12:31:56 Re: Postgres Incompatibility
Previous Message vignesh C 2023-05-17 11:15:24 Re: Support logical replication of DDLs