Обсуждение: How to configure Repmgr

Поиск
Список
Период
Сортировка

How to configure Repmgr

От
jacob ndinkwa
Дата:
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

От
Zhaoxun Yan
Дата:

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

От
Loles
Дата:

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

От
jacob ndinkwa
Дата:
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

От
jacob ndinkwa
Дата:
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

От
Dionysios-Charalampos Vythoulkas
Дата:
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

От
"Tharmarajah, Sam"
Дата:

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

От
Ron Johnson
Дата:
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.)