From: Ron <ronljohnsonjr@gmail.com>
To: pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>
Subject: Postgresql version of SQL Server Availability Groups?
Date: Sun, 18 Sep 2022 09:58:37 -0500
Message-ID: <dabdcc54-98fc-ed7f-4b7b-f504f9f7b732@gmail.com> (raw)
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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: ronljohnsonjr@gmail.com, pgsql-admin@lists.postgresql.org
Subject: Re: Postgresql version of SQL Server Availability Groups?
In-Reply-To: <dabdcc54-98fc-ed7f-4b7b-f504f9f7b732@gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox