Thread: How to configure Repmgr

How to configure Repmgr

From
jacob ndinkwa
Date:
Hello,

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

Thank you,
Jay

Re: How to configure Repmgr

From
Zhaoxun Yan
Date:

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

Re: How to configure Repmgr

From
Loles
Date:

El mié, 15 nov 2023 a las 14:40, Zhaoxun Yan (<yan.zhaoxun@gmail.com>) escribió:

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

Re: How to configure Repmgr

From
jacob ndinkwa
Date:
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:

El mié, 15 nov 2023 a las 14:40, Zhaoxun Yan (<yan.zhaoxun@gmail.com>) escribió:

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
Attachment

Re: How to configure Repmgr

From
jacob ndinkwa
Date:
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:

El mié, 15 nov 2023 a las 14:40, Zhaoxun Yan (<yan.zhaoxun@gmail.com>) escribió:

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

Re: How to configure Repmgr

From
Dionysios-Charalampos Vythoulkas
Date:
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





RE: How to configure Repmgr

From
"Tharmarajah, Sam"
Date:

Not sure of the purpose of going with repmgr. We have been using repmgr and my personal resentment with it is that every time there is a network issue, we end up with two primary and manual intervention is needed to overcome that. From that regard, my preference is Petroni.

 

Good luck.

Sam

Re: How to configure Repmgr

From
Ron Johnson
Date:
On Fri, Jan 12, 2024 at 11:32 AM Tharmarajah, Sam <sambavan.tharmarajah@usask.ca> wrote:

Not sure of the purpose of going with repmgr. We have been using repmgr and my personal resentment with it is that every time there is a network issue, we end up with two primary and manual intervention is needed to overcome that.


That's to be expected with only two nodes.  You can "fix" that by adding a third node for quorum.  (It doesn't even need Postgresql on it; just has to "be there", and running heartbeat software.)