Re: Postgresql version of SQL Server Availability Groups?

Quite possibly.

Thank you.

On 9/18/22 14:23, Licio Matos wrote:
> Hi Ron!
>
> Look if pgpool can handle your request
>
> https://www.pgpool.net/docs/37/en/html/example-cluster.html
>
>
> Em dom., 18 de set. de 2022 às 11:58, Ron <ronljohnsonjr(at)gmail(dot)com> escreveu:
>
> Currently my customer has some very large stand-alone PostgreSQL 9.6
> (will migrate next year to v13) databases, and they want to add HA.
>
> Specifically, they want a "cluster name" which points to a Primary
> database server's IP address, and and which automatically (presumably
> through through a heartbeat and quorum voting system) points to a
> Secondary database server's IP address if the Primary server goes
> down.  Both servers are in the same data center.  (Replication would
> be handled by a standard PostgreSQL method.)
>
> This is *not* load balancing, but a purely HA solution.
>
> I looked at HAProxy, but it seems to be focused on load balancing,
> while the Patroni documentation does not seem to mention a cluster name.
>
> Am I missing something?
>
>
> --
> Angular momentum makes the world go 'round.
>
> --
> Licio Matos

--
Angular momentum makes the world go 'round.