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 1pz2Lk-00026z-JG for pgsql-general@arkaria.postgresql.org; Tue, 16 May 2023 21:36:52 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1pz2Lj-0002l0-A5 for pgsql-general@arkaria.postgresql.org; Tue, 16 May 2023 21:36:51 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pz2Li-0002kq-VU for pgsql-general@lists.postgresql.org; Tue, 16 May 2023 21:36:50 +0000 Received: from mail-yw1-x1136.google.com ([2607:f8b0:4864:20::1136]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1pz2Lf-000DTp-Ds for pgsql-general@lists.postgresql.org; Tue, 16 May 2023 21:36:49 +0000 Received: by mail-yw1-x1136.google.com with SMTP id 00721157ae682-55a26b46003so215438237b3.1 for ; Tue, 16 May 2023 14:36:47 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20221208; t=1684273006; x=1686865006; h=content-transfer-encoding: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=8ltdmlBq+6o7MxT15sXdJghGEsoMFsjVOYEXrh0chMw=; b=a0wYM/iOaR4Fi4n5aEmMS4N2j0TfquBbKz8/0vtQO0Z6fq3bNt1/oo8ohunOUh7dqB 68oP5X0VhLjmQ03Ii5xqRwg4zu+rcmF3tBcMDpr+JJpvgeFqSVealVNXfdxAr+dep2Ro lqyjgbp1PvceTNb+7ivSPYjCEKygPhpgXBAlFTbbxdlUDapcVDA+NMdxhTWv/csneope ijFLqYVf6e8dFjQLaPBSQisaCclLJM3C4cnpN9MwnUHI8Fwp7UP734UlD6ehTUuX0MXB 1uj0jvrVx5grWSBV3c+mHpR2fZoOx+nPh6ODdmuVn0DZtHoNNvfxoGmD4fFFn2/wsAOj 34tQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20221208; t=1684273006; x=1686865006; h=content-transfer-encoding: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=8ltdmlBq+6o7MxT15sXdJghGEsoMFsjVOYEXrh0chMw=; b=fkb88ULyKNkwbw65z9CrxyEFT7PUwIxH1ubIbxajKClKXYspui8lHfsQ6Zg2A/caNv EAQ+/vXeXpkcMLJ6t9y2UUmsua5GlGRGMxAlgqbCgnnekg9VW6yxQ7jMoe2V2FHAscd8 mXZ06yAv/gFICqj0YSY+2iBD+jG1vFWCUw752GCkkGBSVZMZgebdh/O3L0Q1ysIMSMmw PJHr6xdoxJikLDAfT+3UuiN598FiSjNh6nNWO6DfAdxyAMBQ2/Hc1Ha0u7rKZ64u6khS dPmT0Hjc02WMQyTqk1klAAQcTBfl/PYBf0uiN8KHvFK9aC5YZZPWbtIYBVjm0xlodEs0 h28w== X-Gm-Message-State: AC+VfDxXo35+3S6ZM/S14NMHABCCs1zuwsm/g03GuzeJDKswxM3loIg7 aFQHs9RfrOQNvtkbICoh5pnkzY3q6ck= X-Google-Smtp-Source: ACHHUZ5QAeclMGbmVZ3UIhcB+0lvpSwD0oVO7LdkfTVISwH7Oy5vq0mGx/EiIWuILKxnrMgIEghGJg== X-Received: by 2002:a0d:d80b:0:b0:561:9b9e:4182 with SMTP id a11-20020a0dd80b000000b005619b9e4182mr2425294ywe.49.1684273006183; Tue, 16 May 2023 14:36:46 -0700 (PDT) Received: from ?IPV6:2600:1700:bd2c:b810:cc23:f234:2e34:bf3f? ([2600:1700:bd2c:b810:cc23:f234:2e34:bf3f]) by smtp.googlemail.com with ESMTPSA id n64-20020a0de443000000b00555ca01b115sm159092ywe.104.2023.05.16.14.36.45 for (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Tue, 16 May 2023 14:36:45 -0700 (PDT) Message-ID: <3138126f-e6f6-bade-e5ce-c3da3d2c1edb@gmail.com> Date: Tue, 16 May 2023 16:36:45 -0500 MIME-Version: 1.0 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:102.0) Gecko/20100101 Thunderbird/102.10.0 Subject: Re: Postresql HA 2 nodes Content-Language: en-US To: pgsql-general@lists.postgresql.org References: From: Ron In-Reply-To: Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 5/16/23 16:30, Marcello Lorenzi wrote: > Hi everyone, > we're looking for the best solution for a 2-nodes cluster in HA with > Postegresql 15. after some checks we are noticed about pgpool for the > management of balancing and automatic failover. Can it be considered a > viable and manageable solution for production? I implemented a 2/3-node HA system with Postgresql 13 and PgPool. Not in production yet, but seems stable. By 2/3, I mean that there are 2 Pg nodes, and PgPool is installed on them plus a 3rd (smaller) VM.  You really need 3 nodes for quorum voting. -- Born in Arizona, moved to Babylonia.