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 1pjfjo-0006UP-PQ for pgsql-general@arkaria.postgresql.org; Tue, 04 Apr 2023 12:26:13 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1pjfjn-0004bb-MA for pgsql-general@arkaria.postgresql.org; Tue, 04 Apr 2023 12:26:11 +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 1pjfjn-0004bR-92 for pgsql-general@lists.postgresql.org; Tue, 04 Apr 2023 12:26:11 +0000 Received: from mail1.dalibo.net ([51.159.93.128] helo=mail.dalibo.com) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1pjfjk-000pUE-Pi for pgsql-general@lists.postgresql.org; Tue, 04 Apr 2023 12:26:10 +0000 Received: from karst (larco.ioguix.net [78.202.0.6]) by mail.dalibo.com (Postfix) with ESMTPSA id 3451A1F6D2; Tue, 4 Apr 2023 14:25:59 +0200 (CEST) DKIM-Signature: v=1; a=rsa-sha256; c=simple/simple; d=dalibo.com; s=a; t=1680611159; bh=8YlURZNG3Y+foB1KjErrP70aVtJhSUzoLWDNvIQpqaM=; h=Date:From:To:Cc:Subject:In-Reply-To:References:From; b=gfge6C1/KKbrCdmeu2ByM2tvGM3AEjmMF4AoLtoJrMnLfy/TgO99Uv+UTLdJ2dlMq o7s4bCK0EgooaXjR1r5ADpvVK/J3v0co0fX/4ZEDbe//0aQdaJAqRxhn9z+6R3pLEu FUcv6sL0IBFiS2cp+GFyiOwXLFz9wUL4bgxKTluE= Date: Tue, 4 Apr 2023 14:25:58 +0200 From: Jehan-Guillaume de Rorthais To: Inzamam Shafiq Cc: "pgsql-general@lists.postgresql.org" Subject: Re: Patroni vs pgpool II Message-ID: <20230404142558.0e1da98e@karst> In-Reply-To: References: Organization: Dalibo MIME-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Mon, 3 Apr 2023 06:33:46 +0000 Inzamam Shafiq wrote: [...] > Can someone please suggest what is one (Patroni vs PGPool II) is best for > achieving HA/Auto failover, Load balancing for DB servers. Along with this, > can you please share the company/client names using these tools for large PG > databases? Load balancing is best achieved from the application side. The most popular auto failover solution is Patroni. Other solutions are involving Pacemaker to either: * build a shared storage cluster with a standalone instance moving from node to node (but this can include standbys) * build a cluster with a promotable resource using eg. the PAF resource agent, that will decide where to start the standbys and which one to promote. No matter the solution you pick, be prepared to learn and train. A lot.