From: | Licio Matos <licio(dot)matos(at)gmail(dot)com> |
---|---|
To: | Ron <ronljohnsonjr(at)gmail(dot)com> |
Cc: | "pgsql-admin(at)lists(dot)postgresql(dot)org" <pgsql-admin(at)lists(dot)postgresql(dot)org> |
Subject: | Re: Postgresql version of SQL Server Availability Groups? |
Date: | 2022-09-18 19:23:04 |
Message-ID: | CAK6Tc4PH2gCtwVbs_54S4L95gZUCR8E+tjnRvNU-Z_uGKGqmvA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Ron | 2022-09-18 21:47:46 | Re: Postgresql version of SQL Server Availability Groups? |
Previous Message | Ron | 2022-09-18 14:58:37 | Postgresql version of SQL Server Availability Groups? |