From: Dionysios-Charalampos Vythoulkas <dcvythoulkas@gmail.com>
To: jacob ndinkwa <jndinkwa@gmail.com>
Cc: pgsql-admin@lists.postgresql.org
Subject: Re: How to configure Repmgr
Date: Fri, 12 Jan 2024 16:36:03 +0200
Message-ID: <8319736.T7Z3S40VBb@dcv-workpc>
In-Reply-To: 
 <CAKFm-3Boz2L1+gY-5zBDs5e_dkMb-LL1FFaqnbHabs1ciEG30w@mail.gmail.com>
References: 
 <CAKFm-3AE8O8t9N=yeJK23M9SB0wEdePVTCn2b+aJr4h4FFCSBg@mail.gmail.com>
 <B623D2AC-A26C-49EC-89F9-C478643E060C@comcast.net>
 <CAKFm-3Boz2L1+gY-5zBDs5e_dkMb-LL1FFaqnbHabs1ciEG30w@mail.gmail.com>
MIME-Version: 1.0
Content-Transfer-Encoding: quoted-printable
Content-Type: text/plain; charset="UTF-8"
Archived-At: 
 <https://www.postgresql.org/message-id/8319736.T7Z3S40VBb%40dcv-workpc>
Precedence: bulk

On =CE=A0=CE=B1=CF=81=CE=B1=CF=83=CE=BA=CE=B5=CF=85=CE=AE, 12 =CE=99=CE=B1=
=CE=BD=CE=BF=CF=85=CE=B1=CF=81=CE=AF=CE=BF=CF=85 2024 4:08:18 =CE=9C.=CE=9C=
=2E EET jacob ndinkwa wrote:
> All ports are open.
>=20
> I can ssh to both server(s) without any issue.
>=20
> Thanks!
> -Jay
>=20
> On Fri, Jan 12, 2024 at 8:47=E2=80=AFAM Jwiencek3 <jwiencek3@comcast.net>=
 wrote:
> > Make sure all required ports are open
> >=20
> > Sent from my iPad
> >=20
> > On Jan 12, 2024, at 7:26 AM, jacob ndinkwa <jndinkwa@gmail.com> wrote:
> >=20
> > =EF=BB=BF
> > Hello gurus,
> >=20
> > Thank you for your emails and support.
> > I finally configured repmgr and when doing testing I encountered the
> > following issue during switchover testing,
> > I'm running PostgreSQL 15.
> > Please advise.
> >=20
> >=20
> >=20
> > <SSH_Prob.png>
> >=20
> > <switchover_command.png>
> >=20
> >=20
> > Here's the repmgr.conf file:
> >=20
> >=20
> > <repmgr.conf.png>
> >=20
> >=20
> >=20
> > Thanks!
> > -Jay
> >=20
> > On Wed, Nov 15, 2023 at 8:50=E2=80=AFAM Loles <lolesft@gmail.com> wrote:
> >> https://youtu.be/rWsUnaxlkj8?si=3DmNDqkRAY4xxXr5dF
> >>=20
> >> El mi=C3=A9, 15 nov 2023 a las 14:40, Zhaoxun Yan (<yan.zhaoxun@gmail.=
com>)
> >>=20
> >> escribi=C3=B3:
> >>> https://blog.csdn.net/liuhuayang/article/details/106681996
> >>>=20
> >>> On Tue, Nov 14, 2023 at 9:29=E2=80=AFPM jacob ndinkwa <jndinkwa@gmail=
=2Ecom>
> >>>=20
> >>> wrote:
> >>>> Hello,
> >>>>=20
> >>>> Please can someone help me with steps or video links on how to insta=
ll
> >>>> and configure Repmgr for postgreSQL failover?
> >>>>=20
> >>>> Thank you,
> >>>> Jay

1. Can the postgres operating system user SSH passwordless from any server =
to=20
any server?
2. What versions of repmgr are you running?
3. In one of the pictures repmgr complains about the 'cluster' parameter in=
=20
repmgr.conf, but the pitcture from repmgr.conf has no such parameter

dcv