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.94.2) (envelope-from ) id 1rOHsL-002xA9-Ji for pgsql-admin@arkaria.postgresql.org; Fri, 12 Jan 2024 13:47:10 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1rOHsK-0021gH-On for pgsql-admin@arkaria.postgresql.org; Fri, 12 Jan 2024 13:47:08 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rOHsJ-0021g9-QU for pgsql-admin@lists.postgresql.org; Fri, 12 Jan 2024 13:47:08 +0000 Received: from resqmta-h1p-028591.sys.comcast.net ([2001:558:fd02:2446::9]) by makus.postgresql.org with esmtps (TLS1.2) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rOHsG-001BXv-8n for pgsql-admin@lists.postgresql.org; Fri, 12 Jan 2024 13:47:05 +0000 Received: from resomta-h1p-027919.sys.comcast.net ([96.102.179.208]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 256/256 bits) (Client did not present a certificate) by resqmta-h1p-028591.sys.comcast.net with ESMTP id OH7jrx6dcx09sOHsBrqmK1; Fri, 12 Jan 2024 13:46:59 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=comcast.net; s=20190202a; t=1705067219; bh=xqhCzmsXbKEPUUab8hfMH/CdGX39ig8iCfnNmSNGrAc=; h=Received:Received:Content-Type:From:Mime-Version:Subject:Date: Message-Id:To:Xfinity-Spam-Result; b=XK5rbFJ1G5uCgqOiExC0+JtSc1mSAWAiOqmaqDMk48wu8vA6EbvehcVGfNfBHEKBP 4b4K+1kIX1vpM8F5hTgE7CnPQdJlouUfzCDR6UKAh61T13b6hbVTPJniJhuY0Hz4sc DXmWYqqV02jDOLu3ePH3Rc4w6ENFYzJlgsiq2D+C4wubUDHoCL2wxgzKNNqrNtIadG AoZ1L6Y90Ds7/RlSbMsTQPMhN9R74LIGyevc6yZYfClIix8llCiTHpXYniH7R3WrJx sReHeYfpTvX91TSURZxi5HpfjVJXFCfms2Zcmy9oI6gYXreBddK/gUN612wQHXToov caT05RzQcJ2PQ== Received: from smtpclient.apple ([IPv6:2600:1700:1cc0:18e0:b187:12aa:9b48:47d4]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 256/256 bits) (Client did not present a certificate) by resomta-h1p-027919.sys.comcast.net with ESMTPA id OHrWrzDLlC5rcOHrcrbDqx; Fri, 12 Jan 2024 13:46:35 +0000 Content-Type: multipart/alternative; boundary=Apple-Mail-F4C1FECB-1299-4C09-8F8A-DB8BDC74ADF1 Content-Transfer-Encoding: 7bit From: Jwiencek3 Mime-Version: 1.0 (1.0) Subject: Re: How to configure Repmgr Date: Fri, 12 Jan 2024 07:46:08 -0600 Message-Id: References: Cc: Loles , Zhaoxun Yan , pgsql-admin@lists.postgresql.org In-Reply-To: To: jacob ndinkwa X-Mailer: iPad Mail (20G81) X-CMAE-Envelope: MS4xfIYwAuH6k0MV933MSmjpZDGZUU7rn9TLRGpvrvq1oZ0rd35g8AfS9evjRuvevh98TFmJ7nfSJRDYJK3rh1kzJla1OwU+T9OhJbXyaLtiIf4JKyvNstOR D4pcACzZlmJl/d4i45p5xcqzuaLVsT+R1hMTmmfewnDnkxy9HNPcRSxvqdUHNmMzM4Y5xX1N74JqBCGjYFtMUsX9y0d4uwy93ukC7pqqB3fyhCeALkUbxAr9 t71rzBicQ1E/ZfTfcw2vtQg1c5bQagJNnL5aDLqk1d9+Adhk5n4btvRHBrwiraLKa749x0zgnoT+rPRVllkhbRUWQ4W+dgb8Q56HD2O7QwvMwQZzMOWxmuAZ O+pAdrwjj1duatsnH8G4wbQ3MuZVyA== List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --Apple-Mail-F4C1FECB-1299-4C09-8F8A-DB8BDC74ADF1 Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: quoted-printable Make sure all required ports are open
Sent from my iPad

On Jan 12, 2024, at 7:26 AM, jacob ndinkwa <jndinkwa@gmail.c= om> wrote:

=EF=BB=BF
Hello gurus,

Thank y= ou for your emails and support.
I finally configured repmgr and wh= en doing testing I encountered the following issue during switchover testing= ,
I'm running PostgreSQL 15.
Please advise.


<SSH_Prob.png>
<switchover_command.png>


Here's the repmgr.conf file: 


<repmgr.conf.png>



<= /div>
Thanks!
-Jay







=




On Wed, Nov 15, 2023 at 8:= 50=E2=80=AFAM Loles <lolesft@gmail.c= om> wrote:
=
El mi=C3=A9, 15 nov 2023 a las 14:40, Zhaoxun Yan (<yan.zhaoxun@gmail.com>) escr= ibi=C3=B3:

On Tue, Nov 14, 2023 at 9:29=E2=80=AFPM jacob ndinkwa <jndinkwa@gmail.com> wro= te:
Hello,

Please can someone help me with steps or video l= inks on how to install and configure Repmgr for postgreSQL failover?

Thank you,
Jay
= --Apple-Mail-F4C1FECB-1299-4C09-8F8A-DB8BDC74ADF1--