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> (raw)
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>
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@comcast.net> wrote:
> > Make sure all required ports are open
> >
> > Sent from my iPad
> >
> > On Jan 12, 2024, at 7:26 AM, jacob ndinkwa <jndinkwa@gmail.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@gmail.com> wrote:
> >> https://youtu.be/rWsUnaxlkj8?si=mNDqkRAY4xxXr5dF
> >>
> >> El mié, 15 nov 2023 a las 14:40, Zhaoxun Yan (<yan.zhaoxun@gmail.com>)
> >>
> >> escribió:
> >>> https://blog.csdn.net/liuhuayang/article/details/106681996
> >>>
> >>> On Tue, Nov 14, 2023 at 9:29 PM jacob ndinkwa <jndinkwa@gmail.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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: dcvythoulkas@gmail.com, jndinkwa@gmail.com, pgsql-admin@lists.postgresql.org
Subject: Re: How to configure Repmgr
In-Reply-To: <8319736.T7Z3S40VBb@dcv-workpc>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox