pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedHow to configure Repmgr
10+ messages / 7 participants
[nested] [flat]
* How to configure Repmgr
@ 2023-11-14 13:28 jacob ndinkwa <jndinkwa@gmail.com>
0 siblings, 1 reply; 10+ messages in thread
From: jacob ndinkwa @ 2023-11-14 13:28 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org
Hello,
Please can someone help me with steps or video links on how to install and
configure Repmgr for postgreSQL failover?
Thank you,
Jay
^ permalink raw reply [nested|flat] 10+ messages in thread
* Re: How to configure Repmgr
@ 2023-11-15 13:40 Zhaoxun Yan <yan.zhaoxun@gmail.com>
parent: jacob ndinkwa <jndinkwa@gmail.com>
0 siblings, 1 reply; 10+ messages in thread
From: Zhaoxun Yan @ 2023-11-15 13:40 UTC (permalink / raw)
To: jacob ndinkwa <jndinkwa@gmail.com>; +Cc: pgsql-admin@lists.postgresql.org
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
>
^ permalink raw reply [nested|flat] 10+ messages in thread
* Re: How to configure Repmgr
@ 2023-11-15 13:49 Loles <lolesft@gmail.com>
parent: Zhaoxun Yan <yan.zhaoxun@gmail.com>
0 siblings, 1 reply; 10+ messages in thread
From: Loles @ 2023-11-15 13:49 UTC (permalink / raw)
To: Zhaoxun Yan <yan.zhaoxun@gmail.com>; +Cc: jacob ndinkwa <jndinkwa@gmail.com>; pgsql-admin@lists.postgresql.org
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
>>
>
^ permalink raw reply [nested|flat] 10+ messages in thread
* Re: How to configure Repmgr
@ 2024-01-12 13:25 jacob ndinkwa <jndinkwa@gmail.com>
parent: Loles <lolesft@gmail.com>
0 siblings, 1 reply; 10+ messages in thread
From: jacob ndinkwa @ 2024-01-12 13:25 UTC (permalink / raw)
To: Loles <lolesft@gmail.com>; +Cc: Zhaoxun Yan <yan.zhaoxun@gmail.com>; pgsql-admin@lists.postgresql.org
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.
[image: SSH_Prob.png]
[image: switchover_command.png]
Here's the repmgr.conf file:
[image: 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
>>>
>>
Attachments:
[image/png] SSH_Prob.png (112.7K, ../../CAKFm-3AE8O8t9N=yeJK23M9SB0wEdePVTCn2b+aJr4h4FFCSBg@mail.gmail.com/3-SSH_Prob.png)
download | view image
[image/png] switchover_command.png (363.3K, ../../CAKFm-3AE8O8t9N=yeJK23M9SB0wEdePVTCn2b+aJr4h4FFCSBg@mail.gmail.com/4-switchover_command.png)
download | view image
[image/png] repmgr.conf.png (243.2K, ../../CAKFm-3AE8O8t9N=yeJK23M9SB0wEdePVTCn2b+aJr4h4FFCSBg@mail.gmail.com/5-repmgr.conf.png)
download | view image
^ permalink raw reply [nested|flat] 10+ messages in thread
* Re: How to configure Repmgr
@ 2024-01-12 13:46 Jwiencek3 <jwiencek3@comcast.net>
parent: jacob ndinkwa <jndinkwa@gmail.com>
0 siblings, 1 reply; 10+ messages in thread
From: Jwiencek3 @ 2024-01-12 13:46 UTC (permalink / raw)
To: jacob ndinkwa <jndinkwa@gmail.com>; +Cc: Loles <lolesft@gmail.com>; Zhaoxun Yan <yan.zhaoxun@gmail.com>; pgsql-admin@lists.postgresql.org
--Apple-Mail-F4C1FECB-1299-4C09-8F8A-DB8BDC74ADF1
Content-Type: text/html;
charset=utf-8
Content-Transfer-Encoding: quoted-printable
<html><head><meta http-equiv=3D"content-type" content=3D"text/html; charset=3D=
utf-8"></head><body dir=3D"auto">Make sure all required ports are open<br><b=
r><div dir=3D"ltr">Sent from my iPad</div><div dir=3D"ltr"><br><blockquote t=
ype=3D"cite">On Jan 12, 2024, at 7:26 AM, jacob ndinkwa <jndinkwa@gmail.c=
om> wrote:<br><br></blockquote></div><blockquote type=3D"cite"><div dir=3D=
"ltr">=EF=BB=BF<div dir=3D"ltr">Hello gurus,<div><br></div><div>Thank y=
ou for your emails and support.</div><div>I finally configured repmgr and wh=
en doing testing I encountered the following issue during switchover testing=
,</div><div>I'm running PostgreSQL 15.</div><div>Please advise.</div><div><b=
r></div><div><br></div><div><br></div><div><div><SSH_Prob.png></div><b=
r></div><div><div><switchover_command.png></div><br></div><div><br></d=
iv><div>Here's the repmgr.conf file: </div><div><br></div><div><br></di=
v><div><div><repmgr.conf.png></div><br></div><div><br></div><div><br><=
/div><div>Thanks!</div><div>-Jay</div><div><br></div><div><br></div><div><br=
></div><div><br></div><div><br></div><div><br></div><div><br></div><div><br>=
</div><div><br></div><div><br></div><div><br></div></div><br><div class=3D"g=
mail_quote"><div dir=3D"ltr" class=3D"gmail_attr">On Wed, Nov 15, 2023 at 8:=
50=E2=80=AFAM Loles <<a href=3D"mailto:lolesft@gmail.com">lolesft@gmail.c=
om</a>> wrote:<br></div><blockquote class=3D"gmail_quote" style=3D"margin=
:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">=
<div dir=3D"ltr"><a href=3D"https://youtu.be/rWsUnaxlkj8?si=3DmNDqkRAY4xxXr5=
dF" target=3D"_blank">https://youtu.be/rWsUnaxlkj8?si=3DmNDqkRAY4xxXr5dF</a>=
<br></div><br><div class=3D"gmail_quote"><div dir=3D"ltr" class=3D"gmail_att=
r">El mi=C3=A9, 15 nov 2023 a las 14:40, Zhaoxun Yan (<<a href=3D"mailto:=
yan.zhaoxun@gmail.com" target=3D"_blank">yan.zhaoxun@gmail.com</a>>) escr=
ibi=C3=B3:<br></div><blockquote class=3D"gmail_quote" style=3D"margin:0px 0p=
x 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div di=
r=3D"ltr"><a href=3D"https://blog.csdn.net/liuhuayang/article/details/106681=
996" target=3D"_blank">https://blog.csdn.net/liuhuayang/article/details/1066=
81996</a></div><br><div class=3D"gmail_quote"><div dir=3D"ltr" class=3D"gmai=
l_attr">On Tue, Nov 14, 2023 at 9:29=E2=80=AFPM jacob ndinkwa <<a href=3D=
"mailto:jndinkwa@gmail.com" target=3D"_blank">jndinkwa@gmail.com</a>> wro=
te:<br></div><blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0=
.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir=3D"lt=
r">Hello,<div><br></div><div>Please can someone help me with steps or video l=
inks on how to install and configure Repmgr for postgreSQL failover?</div><d=
iv><br></div><div>Thank you,</div><div>Jay</div></div>
</blockquote></div>
</blockquote></div>
</blockquote></div>
</div></blockquote></body></html>=
--Apple-Mail-F4C1FECB-1299-4C09-8F8A-DB8BDC74ADF1--
^ permalink raw reply [nested|flat] 10+ messages in thread
* Re: How to configure Repmgr
@ 2024-01-12 14:08 jacob ndinkwa <jndinkwa@gmail.com>
parent: Jwiencek3 <jwiencek3@comcast.net>
0 siblings, 2 replies; 10+ messages in thread
From: jacob ndinkwa @ 2024-01-12 14:08 UTC (permalink / raw)
To: Jwiencek3 <jwiencek3@comcast.net>; +Cc: Loles <lolesft@gmail.com>; Zhaoxun Yan <yan.zhaoxun@gmail.com>; pgsql-admin@lists.postgresql.org
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
>>>>
>>>
^ permalink raw reply [nested|flat] 10+ messages in thread
* Re: How to configure Repmgr
@ 2024-01-12 14:29 Jwiencek3 <jwiencek3@comcast.net>
parent: jacob ndinkwa <jndinkwa@gmail.com>
1 sibling, 1 reply; 10+ messages in thread
From: Jwiencek3 @ 2024-01-12 14:29 UTC (permalink / raw)
To: jacob ndinkwa <jndinkwa@gmail.com>; +Cc: Loles <lolesft@gmail.com>; Zhaoxun Yan <yan.zhaoxun@gmail.com>; pgsql-admin@lists.postgresql.org
--Apple-Mail-EBD0D920-E6A4-49FC-A01E-109EC0C0AE84
Content-Type: multipart/related;
type="text/html";
boundary=Apple-Mail-BC69972D-B4D3-4C01-9387-FF89AB676D59
Content-Transfer-Encoding: 7bit
--Apple-Mail-BC69972D-B4D3-4C01-9387-FF89AB676D59
Content-Type: text/html;
charset=utf-8
Content-Transfer-Encoding: quoted-printable
<html><head><meta http-equiv=3D"content-type" content=3D"text/html; charset=3D=
utf-8"></head><body dir=3D"auto"><div style=3D"display: block;" class=3D""><=
div style=3D"-webkit-user-select: all; -webkit-user-drag: element; display: i=
nline-block;" class=3D"apple-rich-link" draggable=3D"true" role=3D"link" dat=
a-url=3D"https://www.repmgr.org/docs/current/configuration-password-manageme=
nt.html"><a style=3D"border-radius:10px;font-family:-apple-system, Helvetica=
, Arial, sans-serif;display:block;-webkit-user-select:none;width:300px;user-=
select:none;-webkit-user-modify:read-only;user-modify:read-only;overflow:hid=
den;text-decoration:none;" class=3D"lp-rich-link" rel=3D"nofollow" href=3D"h=
ttps://www.repmgr.org/docs/current/configuration-password-management.html" d=
ir=3D"ltr" role=3D"button" draggable=3D"false" width=3D"300"><table style=3D=
"table-layout:fixed;border-collapse:collapse;width:300px;background-color:#E=
9E9EB;font-family:-apple-system, Helvetica, Arial, sans-serif;" class=3D"lp-=
rich-link-emailBaseTable" cellpadding=3D"0" cellspacing=3D"0" border=3D"0" w=
idth=3D"300"><tbody><tr><td vertical-align=3D"center"><table bgcolor=3D"#E9E=
9EB" cellpadding=3D"0" cellspacing=3D"0" width=3D"300" style=3D"font-family:=
-apple-system, Helvetica, Arial, sans-serif;table-layout:fixed;background-co=
lor:rgba(233, 233, 235, 1);" class=3D"lp-rich-link-captionBar"><tbody><tr><t=
d style=3D"padding:8px 0px 8px 0px;" class=3D"lp-rich-link-captionBar-textSt=
ackItem"><div style=3D"max-width:100%;margin:0px 16px 0px 16px;overflow:hidd=
en;" class=3D"lp-rich-link-captionBar-textStack"><div style=3D"word-wrap:bre=
ak-word;font-weight:500;font-size:12px;overflow:hidden;text-overflow:ellipsi=
s;text-align:left;" class=3D"lp-rich-link-captionBar-textStack-topCaption-le=
ading"><a rel=3D"nofollow" href=3D"https://www.repmgr.org/docs/current/confi=
guration-password-management.html" style=3D"text-decoration: none" draggable=
=3D"false"><font color=3D"#000000" style=3D"color: rgba(0, 0, 0, 1);">4.8.&n=
bsp;Password Management</font></a></div><div style=3D"word-wrap:break-word;f=
ont-weight:400;font-size:11px;overflow:hidden;text-overflow:ellipsis;text-al=
ign:left;" class=3D"lp-rich-link-captionBar-textStack-bottomCaption-leading"=
><a rel=3D"nofollow" href=3D"https://www.repmgr.org/docs/current/configurati=
on-password-management.html" style=3D"text-decoration: none" draggable=3D"fa=
lse"><font color=3D"#A2A2A9" style=3D"color: rgba(60, 60, 67, 0.6);">repmgr.=
org</font></a></div></div></td><td style=3D"padding:6px 12px 6px 0px;" class=
=3D"lp-rich-link-captionBar-rightIconItem" width=3D"36"><a rel=3D"nofollow" h=
ref=3D"https://www.repmgr.org/docs/current/configuration-password-management=
.html" draggable=3D"false"><img style=3D"pointer-events:none !important;disp=
lay:inline-block;width:36px;height:36px;border-radius:3px;" width=3D"36" hei=
ght=3D"36" draggable=3D"false" class=3D"lp-rich-link-captionBar-rightIcon" a=
lt=3D"favicon.ico" src=3D"cid:AB7B9728-E032-424D-925E-CD4013BC0841"></a></td=
></tr></tbody></table></td></tr></tbody></table></a></div></div><br><br><div=
dir=3D"ltr">Sent from my iPad</div><div dir=3D"ltr"><br><blockquote type=3D=
"cite">On Jan 12, 2024, at 8:15 AM, jacob ndinkwa <jndinkwa@gmail.com>=
wrote:<br><br></blockquote></div><blockquote type=3D"cite"><div dir=3D"ltr"=
>=EF=BB=BF<div dir=3D"ltr">All ports are open. <div><br></div><div>I ca=
n ssh to both server(s) without any issue.</div><div><br></div><div>Thanks!<=
/div><div>-Jay</div></div><br><div class=3D"gmail_quote"><div dir=3D"ltr" cl=
ass=3D"gmail_attr">On Fri, Jan 12, 2024 at 8:47=E2=80=AFAM Jwiencek3 <<a h=
ref=3D"mailto:jwiencek3@comcast.net">jwiencek3@comcast.net</a>> wrote:<br=
></div><blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;b=
order-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir=3D"auto">Ma=
ke sure all required ports are open<br><br><div dir=3D"ltr">Sent from my iPa=
d</div><div dir=3D"ltr"><br><blockquote type=3D"cite">On Jan 12, 2024, at 7:=
26 AM, jacob ndinkwa <<a href=3D"mailto:jndinkwa@gmail.com" target=3D"_bl=
ank">jndinkwa@gmail.com</a>> wrote:<br><br></blockquote></div><blockquote=
type=3D"cite"><div dir=3D"ltr">=EF=BB=BF<div dir=3D"ltr">Hello gurus,<div><=
br></div><div>Thank you for your emails and support.</div><div>I finall=
y configured repmgr and when doing testing I encountered the following issue=
during switchover testing,</div><div>I'm running PostgreSQL 15.</div><div>P=
lease advise.</div><div><br></div><div><br></div><div><br></div><div><div>&l=
t;SSH_Prob.png></div><br></div><div><div><switchover_command.png></=
div><br></div><div><br></div><div>Here's the repmgr.conf file: </div><d=
iv><br></div><div><br></div><div><div><repmgr.conf.png></div><br></div=
><div><br></div><div><br></div><div>Thanks!</div><div>-Jay</div><div><br></d=
iv><div><br></div><div><br></div><div><br></div><div><br></div><div><br></di=
v><div><br></div><div><br></div><div><br></div><div><br></div><div><br></div=
></div><br><div class=3D"gmail_quote"><div dir=3D"ltr" class=3D"gmail_attr">=
On Wed, Nov 15, 2023 at 8:50=E2=80=AFAM Loles <<a href=3D"mailto:lolesft@=
gmail.com" target=3D"_blank">lolesft@gmail.com</a>> wrote:<br></div><bloc=
kquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1=
px solid rgb(204,204,204);padding-left:1ex"><div dir=3D"ltr"><a href=3D"http=
s://youtu.be/rWsUnaxlkj8?si=3DmNDqkRAY4xxXr5dF" target=3D"_blank">https://yo=
utu.be/rWsUnaxlkj8?si=3DmNDqkRAY4xxXr5dF</a><br></div><br><div class=3D"gmai=
l_quote"><div dir=3D"ltr" class=3D"gmail_attr">El mi=C3=A9, 15 nov 2023 a la=
s 14:40, Zhaoxun Yan (<<a href=3D"mailto:yan.zhaoxun@gmail.com" target=3D=
"_blank">yan.zhaoxun@gmail.com</a>>) escribi=C3=B3:<br></div><blockquote c=
lass=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid=
rgb(204,204,204);padding-left:1ex"><div dir=3D"ltr"><a href=3D"https://blog=
.csdn.net/liuhuayang/article/details/106681996" target=3D"_blank">https://bl=
og.csdn.net/liuhuayang/article/details/106681996</a></div><br><div class=3D"=
gmail_quote"><div dir=3D"ltr" class=3D"gmail_attr">On Tue, Nov 14, 2023 at 9=
:29=E2=80=AFPM jacob ndinkwa <<a href=3D"mailto:jndinkwa@gmail.com" targe=
t=3D"_blank">jndinkwa@gmail.com</a>> wrote:<br></div><blockquote class=3D=
"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(20=
4,204,204);padding-left:1ex"><div dir=3D"ltr">Hello,<div><br></div><div>Plea=
se can someone help me with steps or video links on how to install and confi=
gure Repmgr for postgreSQL failover?</div><div><br></div><div>Thank you,</di=
v><div>Jay</div></div>
</blockquote></div>
</blockquote></div>
</blockquote></div>
</div></blockquote></div></blockquote></div>
</div></blockquote></body></html>=
--Apple-Mail-BC69972D-B4D3-4C01-9387-FF89AB676D59
Content-Type: image/vnd.microsoft.icon;
name=favicon.ico;
x-apple-part-url=AB7B9728-E032-424D-925E-CD4013BC0841
Content-Disposition: inline;
filename=favicon.ico
Content-Transfer-Encoding: base64
Content-Id: <AB7B9728-E032-424D-925E-CD4013BC0841>
AAABAAEAICAAAAEAIACoEAAAFgAAACgAAAAgAAAAQAAAAAEAIAAAAAAAABAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAQP8c
AED/QAA+/18APf9sAD3/bAA+/18AQP9AAED/HAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA5
/xsAPv9vAD7/wAA+/+8AP///AED//wBB//8AQf//AED//wA///8APv/vAD7/wAA+/28AOf8bAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAABA/xAAPv+AAD//5wBB//8AQP//AD///wA+//8APv//AD7//wA+//8APv//AD7//wA///8A
QP//AEH//wA//+cAPv+AAED/EAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAP/89AD//0gBB//8AP///AD7//wA+//8APv//AD7//wA+//8APv//AD7/
/wA+//8APv//AD7//wA+//8APv//AD///wBB//8AP//SAD//PQAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAD3/XAA///MAQP//AD7//wA+//8APv//AD7//wA+//8A
Pv//AD7//wA+//8APv//AD7//wA+//8APv//AD7//wA+//8APv//AD7//wBA//8AP//zAD3/XAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA+/1sAP//6AD///wA+//8APv//AD7/
/wA+//8APv//AD7//wA+//8APv//AD7//wA+//8APv//AD7//wA+//8APv//AD7//wA+//8APv//
AD7//wA///8AP//6AD7/WwAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAPf87AD//9AA///8A
Pv//AD7//wA+//8APv//AD7//wA+//8APv//AD7//wA+//8APv//AD7//wA+//8APv//AD7//wA+
//8APv//AD7//wA+//8APv//AD7//wA///8AP//0AD3/OwAAAAAAAAAAAAAAAAAAAAAAAAAAAED/
EAA//9QAQP//AD7//wA+//8APv//AD7//wA+//8APv//AD7//wA+//8APv//AD7//wA+//8APv//
AD7//wA+//8APv//AD7//wA+//8APv//AD7//wA+//8APv//AD7//wBA//8AP//UAED/EAAAAAAA
AAAAAAAAAAAAAAAAPv+AAEH//wA+//8APv//AD7//wA+//8APv//AD7//wA+//8APv//AD7//wA6
//8AOv//ADn//wA3//8AOf//AD7//wA+//8APv//AD7//wA+//8APv//AD7//wA+//8APv//AD7/
/wBB//8APv+AAAAAAAAAAAAAAAAAAD3/GQA+/+oAP///AD7//wA+//8APv//AD7//wA+//8APv//
AD7//wA+//8AOf//eJn//7/O//+7y///obj//0Vx//8AOv//AD7//wA+//8APv//AD7//wA+//8A
Pv//AD7//wA+//8APv//AD///wA+/+oAPf8ZAAAAAAAAAAAAPv9vAEH//wA+//8APv//AD7//wA+
//8APf//ADj//wA2//8AN///ADn//wA7//85aP//dZT//8LR////////+vv//0d0//8AOP//ADn/
/wA3//8ANv//ADj//wA+//8APv//AD7//wA+//8APv//AEH//wA+/28AAAAAAAD/AgA+/8IAQP//
AD7//wA+//8APv//AD3//wE9//9Kdv//gaD//562//+ctP//BkL//2+S//+uwP//vs7///39////
////p7z//wY///+as///nLT//4Ce//9JdP//AD3//wA9//8APv//AD7//wA+//8AQP//AD7/wgAA
/wIAQP8cAD7/8AA+//8APv//AD7//wA+//8CPP//kqz///////////////////Dz//8NR///tcf/
//////////////////////+ww///DUj///Dz//////////////////+Qq///Ajv//wA+//8APv//
AD7//wA+//8APv/wAED/HAA//0EAP///AD7//wA+//8APv//ADn//z1s////////////////////
////6O3//wxH//+vwv///////////////////////6/C//8MR///6O3/////////////////////
//88bP//ADn//wA+//8APv//AD7//wA///8AP/9BAD3/YABA//8APv//AD7//wA+//8ANv//a4//
///////////////////////o7f//DEf//6/C////////////////////////r8L//wxH///o7f//
/////////////////////2uP//8ANv//AD7//wA+//8APv//AED//wA9/2AAPf9sAEH//wA+//8A
Pv//AD7//wA5//8/bf//+fr//////////////////+jt//8MR///r8L/////////////////////
//+ww///DEf//+jt///////////////////5+v//P23//wA5//8APv//AD7//wA+//8AQf//ADz/
bgA9/2wAQf//AD7//wA+//8APv//AD3//wI9///E0///////////////////6O3//wxH//+vwv//
/////////////////////6W7//8KRv//6O3//////////////////8TS//8CPf//AD3//wA+//8A
Pv//AD7//wBB//8AP/9uAD3/YABA//8APv//AD7//wA+//8AOf//OGj///f5////////////////
///o7f//DEf//7XG///////////////////7/P//RnP//wxH///o7f//////////////////9/n/
/zho//8AOf//AD7//wA+//8APv//AED//wA9/2AAP/9BAD///wA+//8APv//AD7//wA2//9rj///
/////////////////////+jt//8NSP//fZz//8PS///C0f//q7///0t2//8AOP//E03//+jt////
////////////////////a4///wA2//8APv//AD7//wA+//8AP///AD//QQBA/xwAPv/wAD7//wA+
//8APv//ADj//0Nx////////////////////////7vL//xRO//8AOv//AD3//wA9//8AOf//ADj/
/wA8//8UTv//7vL///////////////////////9Dcf//ADj//wA+//8APv//AD7//wA+//AAQP8c
AAD/AgA+/8IAQP//AD7//wA+//8APv//Az3//4Wi///p7v//7/P//9/n//+zxf//C0b//wA8//8A
Pv//AD7//wA+//8APv//AD3//wtG//+zxf//3+f//+/z///p7v//haL//wM9//8APv//AD7//wA+
//8AQP//AD7/wgAA/wIAAAAAAD7/bwBB//8APv//AD7//wA+//8APf//ADn//xZP//8bUv//DEf/
/wA+//8APf//AD7//wA+//8APv//AD7//wA+//8APv//AD3//wA+//8MR///G1L//xZP//8AOf//
AD3//wA+//8APv//AD7//wBB//8APv9vAAAAAAAAAAAAPf8ZAD7/6gA///8APv//AD7//wA+//8A
Pv//ADz//wA7//8APf//AD3//wA+//8APv//AD7//wA+//8APv//AD7//wA+//8APv//AD3//wA9
//8AO///ADz//wA+//8APv//AD7//wA+//8AP///AD7/6gA9/xkAAAAAAAAAAAAAAAAAPv+AAEH/
/wA+//8APv//AD7//wA+//8APv//AD7//wA+//8APv//AD7//wA+//8APv//AD7//wA+//8APv//
AD7//wA+//8APv//AD7//wA+//8APv//AD7//wA+//8APv//AD7//wBB//8APv+AAAAAAAAAAAAA
AAAAAAAAAABA/xAAP//UAED//wA+//8APv//AD7//wA+//8APv//AD7//wA+//8APv//AD7//wA+
//8APv//AD7//wA+//8APv//AD7//wA+//8APv//AD7//wA+//8APv//AD7//wA+//8AQP//AD//
1ABA/xAAAAAAAAAAAAAAAAAAAAAAAAAAAAA9/zsAQP/0AD///wA+//8APv//AD7//wA+//8APv//
AD7//wA+//8APv//AD7//wA+//8APv//AD7//wA+//8APv//AD7//wA+//8APv//AD7//wA+//8A
Pv//AD///wA///QAPf87AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA+/1sAP//6AD///wA+
//8APv//AD7//wA+//8APv//AD7//wA+//8APv//AD7//wA+//8APv//AD7//wA+//8APv//AD7/
/wA+//8APv//AD7//wA///8AP//6AD7/WwAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAA9/1wAP//zAED//wA+//8APv//AD7//wA+//8APv//AD7//wA+//8APv//AD7//wA+//8A
Pv//AD7//wA+//8APv//AD7//wA+//8AQP//AD//8wA9/1wAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA//z0AP//SAEH//wA///8APv//AD7//wA+//8APv//AD7/
/wA+//8APv//AD7//wA+//8APv//AD7//wA+//8AP///AEH//wA//9IAP/89AAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAABA/xAAPv+AAD//5wBB//8A
QP//AD///wA+//8APv//AD7//wA+//8APv//AD7//wA///8AQP//AEH//wA//+cAPv+AAED/EAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAOf8bAD7/bwA+/8AAPv/vAD///wBA//8AQf//AEH//wBA//8AP///AD7/7wA+/8AAPv9v
ADn/GwAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAABA/xwAQP9AAD7/XwA9/2wAPf9sAD7/XwBA
/0AAQP8cAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA//AP
//+AAf/+AAB//AAAP/gAAB/wAAAP4AAAB8AAAAPAAAADgAAAAYAAAAEAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAgAAAAYAAAAHAAAADwAAAA+AAAAfwAAAP+AAAH/wAAD/+
AAB//4AB///wD/8=
--Apple-Mail-BC69972D-B4D3-4C01-9387-FF89AB676D59--
--Apple-Mail-EBD0D920-E6A4-49FC-A01E-109EC0C0AE84--
Attachments:
[image/vnd.microsoft.icon] favicon.ico (4.2K, ../../7C5C297D-B74C-4527-82E4-34A215E43060@comcast.net/2-favicon.ico)
download | view image
^ permalink raw reply [nested|flat] 10+ messages in thread
* Re: How to configure Repmgr
@ 2024-01-12 14:36 Dionysios-Charalampos Vythoulkas <dcvythoulkas@gmail.com>
parent: jacob ndinkwa <jndinkwa@gmail.com>
1 sibling, 0 replies; 10+ messages in thread
From: Dionysios-Charalampos Vythoulkas @ 2024-01-12 14:36 UTC (permalink / raw)
To: jacob ndinkwa <jndinkwa@gmail.com>; +Cc: pgsql-admin@lists.postgresql.org
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
^ permalink raw reply [nested|flat] 10+ messages in thread
* RE: How to configure Repmgr
@ 2024-01-12 15:32 Tharmarajah, Sam <sambavan.tharmarajah@usask.ca>
parent: Jwiencek3 <jwiencek3@comcast.net>
0 siblings, 1 reply; 10+ messages in thread
From: Tharmarajah, Sam @ 2024-01-12 15:32 UTC (permalink / raw)
To: Jwiencek3 <jwiencek3@comcast.net>; jacob ndinkwa <jndinkwa@gmail.com>; +Cc: Loles <lolesft@gmail.com>; Zhaoxun Yan <yan.zhaoxun@gmail.com>; pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>
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
^ permalink raw reply [nested|flat] 10+ messages in thread
* Re: How to configure Repmgr
@ 2024-01-12 16:59 Ron Johnson <ronljohnsonjr@gmail.com>
parent: Tharmarajah, Sam <sambavan.tharmarajah@usask.ca>
0 siblings, 0 replies; 10+ messages in thread
From: Ron Johnson @ 2024-01-12 16:59 UTC (permalink / raw)
To: Tharmarajah, Sam <sambavan.tharmarajah@usask.ca>; +Cc: Jwiencek3 <jwiencek3@comcast.net>; jacob ndinkwa <jndinkwa@gmail.com>; Loles <lolesft@gmail.com>; Zhaoxun Yan <yan.zhaoxun@gmail.com>; pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>
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.)
^ permalink raw reply [nested|flat] 10+ messages in thread
end of thread, other threads:[~2024-01-12 16:59 UTC | newest]
Thread overview: 10+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2023-11-14 13:28 How to configure Repmgr jacob ndinkwa <jndinkwa@gmail.com>
2023-11-15 13:40 ` Zhaoxun Yan <yan.zhaoxun@gmail.com>
2023-11-15 13:49 ` Loles <lolesft@gmail.com>
2024-01-12 13:25 ` jacob ndinkwa <jndinkwa@gmail.com>
2024-01-12 13:46 ` Jwiencek3 <jwiencek3@comcast.net>
2024-01-12 14:08 ` jacob ndinkwa <jndinkwa@gmail.com>
2024-01-12 14:29 ` Jwiencek3 <jwiencek3@comcast.net>
2024-01-12 15:32 ` Tharmarajah, Sam <sambavan.tharmarajah@usask.ca>
2024-01-12 16:59 ` Ron Johnson <ronljohnsonjr@gmail.com>
2024-01-12 14:36 ` Dionysios-Charalampos Vythoulkas <dcvythoulkas@gmail.com>
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