Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1ojt7m-00009z-Af for pgsql-admin@arkaria.postgresql.org; Sun, 16 Oct 2022 02:11:34 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1ojt7l-0002tM-5W for pgsql-admin@arkaria.postgresql.org; Sun, 16 Oct 2022 02:11:33 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1ojt7k-0002sK-RM for pgsql-admin@lists.postgresql.org; Sun, 16 Oct 2022 02:11:32 +0000 Received: from mail-oa1-x32.google.com ([2001:4860:4864:20::32]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1ojt7i-0000i2-KJ for pgsql-admin@lists.postgresql.org; Sun, 16 Oct 2022 02:11:31 +0000 Received: by mail-oa1-x32.google.com with SMTP id 586e51a60fabf-1370acb6588so10064398fac.9 for ; Sat, 15 Oct 2022 19:11:30 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20210112; h=in-reply-to:from:references:to:content-language:subject:user-agent :mime-version:date:message-id:from:to:cc:subject:date:message-id :reply-to; bh=3Au1U3enxFiK3bDTDNEU9yqUjHjiOclFhcSmnbwg0Xk=; b=LzfcRmrGWPiTNcnebUxNGRaEb/PrKYrXOx+E2OcQ+YbJ5cQESwd3x76BC7SjB8MxJN NI81x65lA9kdy+Qs/Gt/7eb70iR0hVlgnfvQdrccJf+Bnuff8qfwauORhRRAhz7H5Gtn x3shJQvAIF0uJSpLXFVCuV5HS3e1/7Z0P/xX2wz63i76/a+i2MytyVxhGYxEkea+E3Vm k3rtDSFkvliDruTJBgZGtO8zStIal7M1Z0CC0sbKrBcFOO7MG9CtDH3WkGUrwjD4UgWx MFf3B//rI8OZ4TZ0ohdZPG4ZQqiqKDc03dr6XJGXzKrytqNw10j7Hr+WvoCbbFHX7jC8 SRTg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=in-reply-to:from:references:to:content-language:subject:user-agent :mime-version:date:message-id:x-gm-message-state:from:to:cc:subject :date:message-id:reply-to; bh=3Au1U3enxFiK3bDTDNEU9yqUjHjiOclFhcSmnbwg0Xk=; b=BxROrKm9qVPixnCGRLjeIYt/d5CAOy0whLz+1dufLYR4b/6BdfiSNvA3gFY5/RkxzT GVPnEM9fMfDPmmHk9UxewenxtPydDw0VMNFTmQn5osXXXVUXvV2x9lI27I+bdRt2cPxd bEIaijBqTuj9C1YanQvhStvvG1qm4DrHyK0sGPyDZJUHCvnW33dmxa9d4dpKFFZRQTd7 +HpWoWbOw8qpVXvE0WgL37ahuD7o+z5kPkYvxJjrD7axiEfM42EoZW6fYEQKm0JUVZ3E XRTJDO1Q5VsnuNcesvCd4FXaHUvjwS6dy/IIVzTfLS6foRGayE+Fp7Z9vpYrveg/hCRi EOrw== X-Gm-Message-State: ACrzQf2+3hykRoTxb5XVIS4NDsQZmvfETjEHE4LYMwO/xJNTmK1TWlCC R3mMT4t9kRxmP5MW1/t4af8uinejAzs= X-Google-Smtp-Source: AMsMyM5AsCIdOmzGpWzsDVuzvtKKcDs2mf4lP4t9QnP96/6KETshwiky2+x6mrFZekyGXkOFjpEUbg== X-Received: by 2002:a05:6870:630e:b0:10d:ac9c:362b with SMTP id s14-20020a056870630e00b0010dac9c362bmr12110269oao.157.1665886289675; Sat, 15 Oct 2022 19:11:29 -0700 (PDT) Received: from [192.168.88.10] (ip68-11-68-85.no.no.cox.net. [68.11.68.85]) by smtp.googlemail.com with ESMTPSA id r6-20020a056830120600b006619a60a81bsm3165789otp.14.2022.10.15.19.11.28 for (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Sat, 15 Oct 2022 19:11:29 -0700 (PDT) Content-Type: multipart/alternative; boundary="------------lLvcMndJIABoYj0hWHlTvko5" Message-ID: <15f921c7-e6c6-8a88-1895-02a62d41118c@gmail.com> Date: Sat, 15 Oct 2022 21:11:28 -0500 MIME-Version: 1.0 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:102.0) Gecko/20100101 Thunderbird/102.2.2 Subject: Re: Open source HA setup for postgres Content-Language: en-US To: pgsql-admin@lists.postgresql.org References: From: Ron In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk This is a multi-part message in MIME format. --------------lLvcMndJIABoYj0hWHlTvko5 Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit On 10/14/22 11:33, Tharmarajah, Sam wrote: > > 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. > I meant PgBouncer, not PgPool.  No SELECT load balancing, though. https://www.pgbouncer.org/ -- Angular momentum makes the world go 'round. --------------lLvcMndJIABoYj0hWHlTvko5 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: 8bit On 10/14/22 11:33, Tharmarajah, Sam wrote:

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.


I meant PgBouncer, not PgPool.  No SELECT load balancing, though.

https://www.pgbouncer.org/

--
Angular momentum makes the world go 'round.
--------------lLvcMndJIABoYj0hWHlTvko5--