Re: Open source HA setup for postgres

Holger Jakobs <holger@xxxxxxxxxx> · Sat, 15 Oct 2022 20:18:55 +0200



    Hi Sam,
    There is a whole chapter about this topic in the official
      documentation

    
    https://www.postgresql.org/docs/current/high-availability.html
    Plus, there are products like pg_auto_failover by Citus
      (Microsoft) and the template Patroni.

    
    Regards,
    Holger

    
    Am 14.10.22 um 18:33 schrieb
      Tharmarajah, Sam:

    
        Hi,
         
        We are wondering what is open-source tools
          being used to set up the HA. We are also looking for a way to
          pass the reads to all the HA nodes and writes to the primary.
           One of the pressing criteria is the HA also should be able to
          handle the node being taken down during patching and should be
          able to fail back or recover seamlessly without any manual
          intervention.
         
        This is the first time we are embarking on
          HA, so would like some advice and caveats to avoid.
         
        Thanx
        Sam
      
    
    -- 
Holger Jakobs, Bergisch Gladbach, Tel. +49-178-9759012
  

Attachment:
OpenPGP_signature

Description: OpenPGP digital signature