Content-Type: multipart/alternative;
 boundary="------------bpsnWauDnKa3jUVqTYADAe1U"
Message-ID: <dabdcc54-98fc-ed7f-4b7b-f504f9f7b732@gmail.com>
Date: Sun, 18 Sep 2022 09:58:37 -0500
MIME-Version: 1.0
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:91.0) Gecko/20100101
 Thunderbird/91.9.1
To: "pgsql-admin@lists.postgresql.org" <pgsql-admin@lists.postgresql.org>
Content-Language: en-US
From: Ron <ronljohnsonjr@gmail.com>
Subject: Postgresql version of SQL Server Availability Groups?
Archived-At: 
 <https://www.postgresql.org/message-id/dabdcc54-98fc-ed7f-4b7b-f504f9f7b732%40gmail.com>
Precedence: bulk

This is a multi-part message in MIME format.
--------------bpsnWauDnKa3jUVqTYADAe1U
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit

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.
--------------bpsnWauDnKa3jUVqTYADAe1U
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: 8bit

<html>
  <head>

    <meta http-equiv="content-type" content="text/html; charset=UTF-8">
  </head>
  <body>
    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.<br>
    <br>
    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.)<br>
    <br>
    This is <b>not</b> load balancing, but a purely HA solution.<br>
    <br>
    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.<br>
    <br>
    Am I missing something?<br>
    <br>
    <div class="moz-signature">-- <br>
      Angular momentum makes the world go 'round.</div>
  </body>
</html>

--------------bpsnWauDnKa3jUVqTYADAe1U--