Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1vJCeC-00EPXE-31 for pgsql-admin@arkaria.postgresql.org; Wed, 12 Nov 2025 15:20:35 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vJCeA-00CJp7-20 for pgsql-admin@arkaria.postgresql.org; Wed, 12 Nov 2025 15:20:34 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1vJCeA-00CJoz-0j for pgsql-admin@lists.postgresql.org; Wed, 12 Nov 2025 15:20:34 +0000 Received: from mail-wm1-x32b.google.com ([2a00:1450:4864:20::32b]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1vJCe8-007MeG-0S for pgsql-admin@lists.postgresql.org; Wed, 12 Nov 2025 15:20:33 +0000 Received: by mail-wm1-x32b.google.com with SMTP id 5b1f17b1804b1-477442b1de0so6900215e9.1 for ; Wed, 12 Nov 2025 07:20:31 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1762960829; x=1763565629; darn=lists.postgresql.org; h=to:subject:message-id:date:from:mime-version:from:to:cc:subject :date:message-id:reply-to; bh=bQT/OiI1g8FryMKC++kOO7jahfC4RBI8Ced0UKpHGfg=; b=MEEplmprzb1s+gDbvgqSBZPzlxfpsUDzh+0x2EGJZQN/ir+sYr4gUFTZnbObU1TcFH 6vVNAgWLSVOORdRTEV5Iuzr8+X8N5uzki+J4qOzNZ60MxJC8OqJG8QTzR70EJUKDjrR5 KsIEYkg87yqz1aN9PZo1inIPpc9Ar80zNVHPEKWUPZQHAegB5a8EefbmSwWdw24cv3Kt tf/7yMPbJUoZAJG9tRtq/oSUxZmCJKYHh3/TFo6uTFNfxrrM0AL+l1uZWzT4n1GaqtVG 7cxzbqfIyEuq65T8cRat51YZv0RZz5ZnVDbW77mw8Nqlp2vRfrobyngdAFK0wPf8CXCi 1Slg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1762960829; x=1763565629; h=to:subject:message-id:date:from:mime-version:x-gm-gg :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to; bh=bQT/OiI1g8FryMKC++kOO7jahfC4RBI8Ced0UKpHGfg=; b=ecQPwNdTgCokDFRcPyWo7Z3xOIkmYwR9swFIs0BuuQ4sBblJmy4Pu9cnN463z3vYsW 4J07UqvI+xiQT7qO/i9SZIwaKtpWI+PvKGPMiqJEfP+b4eFEIDsIhbQfmPdk/Mxk7ENO Fj2cpRNxJ+1XYUn+XZfg/1NmgQ0O7bCpKFBSg6oU6lfJ+HvXWvTfjn88iTe1dFhGF0JR F2faMU+CWH1t3rhpXES4JS8YObiSREZ7YSL+aCDFNuy9uYc6ob6Z+kKRywmmRzDtOxVz x9zwx4G4x4qQeLLsFSS76lET+vaK45eghnkd9Mggb+n5ztQy+RPrzdFjACMXXvNIicvc Ivjg== X-Gm-Message-State: AOJu0YxiHTFEGrcLlLuhFZpZP3vyios87qwCmWDifWEw7+M46u4yZ/fx 3Gt7BQdUyXZ/edOl3WtPOvtDys6dc5z3FZ6ENPMu+HRsh/A9kIDehfSmspt5wdebm4yzYu9PIlm lSFvypj/xm5UW3MG51V77mhNzAuCH76VSk7af X-Gm-Gg: ASbGncuERsiLbdlhiU7g4TbS3qRilx4RQJ3k2oRk70Y4z3OzgQ+62GsTiv5uK5Nt9ik FwPXO1Fbgqlc0aq+pDob+dI1+hVoogkmaYNxIEOggJqfybll+vfKhDcWJ0roTc3YtSoSYxDAPDu Asyw0ibPDdjn56Q/v+37kFbOKgp5+Pt3cc2F+g05wKY1ePdPJBhizmN2Q2QHw52qBvdpgmZQU8E dpG7iUmn0lfoAbjSd4SWfDxiZkxCPQubTvy40S6dSrgpzM2VF6ZZ7Si47sF1B+vrVTP0hU= X-Google-Smtp-Source: AGHT+IFOnySjlK9Yj9yLYO0DrEJqA1vXV5NQSEniqw4PLzhdkyXCuhrmzIGFJrNAn9Qf/ZNNaIW/pLXQYsP34+aWVLU= X-Received: by 2002:a5d:5f53:0:b0:42b:3302:f7d4 with SMTP id ffacd0b85a97d-42b4bb98988mr3163639f8f.22.1762960828601; Wed, 12 Nov 2025 07:20:28 -0800 (PST) MIME-Version: 1.0 From: Joseph Craig Date: Wed, 12 Nov 2025 09:20:16 -0600 X-Gm-Features: AWmQ_bkZCvDB1QlL9HYzM7KGW3zy3d0BTUK7w_r8ASDBO1Y2l7NaB0pcFfyXfK4 Message-ID: Subject: Postgres HA Deployment Questions To: pgsql-admin@lists.postgresql.org Content-Type: multipart/alternative; boundary="000000000000f1182b0643674d95" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000f1182b0643674d95 Content-Type: text/plain; charset="UTF-8" Hello, I've got to deploy some HA deployments of Postgres and wanted to know what the actual in production architecture was for HA deployments. I've done some googling and found a few different options, but wanted to see what folks that actually use and support Postgres are doing these days. In my lab I'm working on a Postgres and Pgpool2 setup but having issues making pgpool2 HA, so that leads me back to this group. Is that the commonly used HA solution or is there another one that is used more? Thanks, Joe Craig --000000000000f1182b0643674d95 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Hello,

I've got to deploy some HA d= eployments of Postgres and wanted to know what the actual in production arc= hitecture was for HA deployments. I've done some googling and found a f= ew different options, but wanted to see what folks that actually use and su= pport Postgres are doing these days.=C2=A0

In my l= ab I'm working on a Postgres and Pgpool2 setup but having issues making= pgpool2 HA, so that leads me back to this group. Is that the commonly used= HA solution or is there another one that is used more?

Thanks,
Joe Craig

--000000000000f1182b0643674d95--