Re: How to configure Repmgr

On Παρασκευή, 12 Ιανουαρίου 2024 4:08:18 Μ.Μ. EET jacob ndinkwa wrote:
> All ports are open.
>
> I can ssh to both server(s) without any issue.
>
> Thanks!
> -Jay
>
> On Fri, Jan 12, 2024 at 8:47 AM Jwiencek3 <jwiencek3(at)comcast(dot)net> wrote:
> > Make sure all required ports are open
> >
> > Sent from my iPad
> >
> > On Jan 12, 2024, at 7:26 AM, jacob ndinkwa <jndinkwa(at)gmail(dot)com> wrote:
> >
> > 
> > Hello gurus,
> >
> > 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.
> >
> >
> >
> > <SSH_Prob.png>
> >
> > <switchover_command.png>
> >
> >
> > Here's the repmgr.conf file:
> >
> >
> > <repmgr.conf.png>
> >
> >
> >
> > Thanks!
> > -Jay
> >
> > On Wed, Nov 15, 2023 at 8:50 AM Loles <lolesft(at)gmail(dot)com> wrote:
> >> https://youtu.be/rWsUnaxlkj8?si=mNDqkRAY4xxXr5dF
> >>
> >> El mié, 15 nov 2023 a las 14:40, Zhaoxun Yan (<yan(dot)zhaoxun(at)gmail(dot)com>)
> >>
> >> escribió:
> >>> https://blog.csdn.net/liuhuayang/article/details/106681996
> >>>
> >>> On Tue, Nov 14, 2023 at 9:29 PM jacob ndinkwa <jndinkwa(at)gmail(dot)com>
> >>>
> >>> wrote:
> >>>> Hello,
> >>>>
> >>>> Please can someone help me with steps or video links on how to install
> >>>> and configure Repmgr for postgreSQL failover?
> >>>>
> >>>> Thank you,
> >>>> Jay

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

dcv