Thread: How to configure Repmgr
Hello,
Please can someone help me with steps or video links on how to install and configure Repmgr for postgreSQL failover?
Thank you,
Jay
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
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
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.
Here's the repmgr.conf file:
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
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 openSent from my iPadOn 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!-JayOn 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
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
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
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.)