MIME-Version: 1.0
References: 
 <CAP0GqH7hYsFGmLg3Ge-_Lf_VEeES8yeHpOhSvn071=XRnmVxTw@mail.gmail.com>
 <CAFVRaQ3No2rEYjkuKsxNNMCP16_J_kjDm_pv0+CYwTLXsjE8OQ@mail.gmail.com>
In-Reply-To: 
 <CAFVRaQ3No2rEYjkuKsxNNMCP16_J_kjDm_pv0+CYwTLXsjE8OQ@mail.gmail.com>
From: Imran Khan <imran.k.23@gmail.com>
Date: Wed, 1 Oct 2025 13:12:40 +0300
Message-ID: 
 <CAC4eXDgNZM12t8OgKYhjbu_7NFcsu0qG5aTpdXmbN=fmmp-5Tw@mail.gmail.com>
Subject: Re: repmgr cannot bring up the standby database after switchover
 manaully
To: Tayyab Fayyaz <tayyab.humayl@gmail.com>
Cc: Chris Lee <clee.hk@gmail.com>, pgsql-admin <pgsql-admin@postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000755a9f0640161c24"
Archived-At: 
 <https://www.postgresql.org/message-id/CAC4eXDgNZM12t8OgKYhjbu_7NFcsu0qG5aTpdXmbN%3Dfmmp-5Tw%40mail.gmail.com>
Precedence: bulk

--000000000000755a9f0640161c24
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

Hi Tayyab,

 Is this a default behavior? We have 4 nodes cluster but never had issue in
switchovers.

Thanks,
Imran

On Wed, Oct 1, 2025, 1:10=E2=80=AFPM Tayyab Fayyaz <tayyab.humayl@gmail.com=
> wrote:

> Hello Chris,
>
> I faced this issue it will not add automatically as standby you have to
> add it manually.
>
> But I wrote a script which perform to add old primary as standby once it'=
s
> back online.
>
> Tayyab
>
>
> On Wed, 1 Oct 2025, 3:02=E2=80=AFpm Chris Lee, <clee.hk@gmail.com> wrote:
>
>> Hi all,
>>
>> I have 2 postgresql servers. One is the primary and another one is the
>> standby. I am trying to setup repmgr to do the switchover manually.
>> Passwordless ssh have been setup for postgres ID on both servers.
>>
>> I use this command "repmgr standby switchover --log-level=3DDEBUG
>> --verbose". The standy database is able to promote to be the primary. Fo=
r
>> the previous primary database, it was shutdown. It was not able to bring=
 up
>> as standby by repmgr.
>>
>> Does anyone encounter this issue before? Thanks a lot for any suggestion=
s.
>>
>> Here is my OS and DB versions:
>>
>> OS version: CentOS Stream release 8
>> Postgres DB version:  15.12
>> rempmgr version: 5.5.0
>>
>> Here is the repmgr conf files:
>> >>>>>
>> node_id=3D1  # Use 2 on standby
>> node_name=3D'primary'
>> conninfo=3D'host=3Dcentos804 user=3Drepmgr dbname=3Drepmgr password=3Dxx=
x
>> connect_timeout=3D15'
>> use_primary_conninfo_password=3Dtrue
>> data_directory=3D'/var/lib/pgsql/15/data'  # Adjust for your setup
>> pg_bindir=3D'/usr/pgsql-15/bin'
>> service_start_command =3D 'sudo systemctl start postgresql-15'
>> service_stop_command  =3D 'sudo systemctl stop postgresql-15'
>> <<<<<
>>
>> >>>>>
>> node_id=3D2  # Use 2 on standby
>> node_name=3D'standby'
>> conninfo=3D'host=3Dcentos803 user=3Drepmgr dbname=3Drepmgr password=3Dxx=
x
>> connect_timeout=3D15'
>> use_primary_conninfo_password=3Dtrue
>> data_directory=3D'/var/lib/pgsql/15/data'  # Adjust for your setup
>> pg_bindir=3D'/usr/pgsql-15/bin'
>> service_start_command =3D 'sudo systemctl start postgresql-15'
>> service_stop_command  =3D 'sudo systemctl stop postgresql-15'
>> <<<<<
>>
>> Regards,
>> Chris
>>
>

--000000000000755a9f0640161c24
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"auto">Hi Tayyab,<div dir=3D"auto"><br></div><div dir=3D"auto">=
=C2=A0Is this a default behavior? We have 4 nodes cluster but never had iss=
ue in switchovers.=C2=A0</div><div dir=3D"auto"><br></div><div dir=3D"auto"=
>Thanks,=C2=A0</div><div dir=3D"auto">Imran</div></div><br><div class=3D"gm=
ail_quote gmail_quote_container"><div dir=3D"ltr" class=3D"gmail_attr">On W=
ed, Oct 1, 2025, 1:10=E2=80=AFPM Tayyab Fayyaz &lt;<a href=3D"mailto:tayyab=
.humayl@gmail.com">tayyab.humayl@gmail.com</a>&gt; wrote:<br></div><blockqu=
ote class=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:1px #ccc s=
olid;padding-left:1ex"><div dir=3D"auto"><div>Hello Chris,<div dir=3D"auto"=
><br></div><div dir=3D"auto">I faced this issue it will not add automatical=
ly as standby you have to add it manually.</div><div dir=3D"auto"><br></div=
><div dir=3D"auto">But I wrote a script which perform to add old primary as=
 standby once it&#39;s back online.</div><div dir=3D"auto"><br></div><div d=
ir=3D"auto">Tayyab</div><br><br><div class=3D"gmail_quote"><div dir=3D"ltr"=
 class=3D"gmail_attr">On Wed, 1 Oct 2025, 3:02=E2=80=AFpm Chris Lee, &lt;<a=
 href=3D"mailto:clee.hk@gmail.com" target=3D"_blank" rel=3D"noreferrer">cle=
e.hk@gmail.com</a>&gt; wrote:<br></div><blockquote class=3D"gmail_quote" st=
yle=3D"margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div =
dir=3D"ltr">Hi all,<br><br>I have 2 postgresql servers. One is the primary =
and another one is the standby. I am trying to setup repmgr to do the switc=
hover manually. Passwordless ssh have been setup for postgres ID on both se=
rvers.<br><br>I use this command &quot;repmgr standby switchover --log-leve=
l=3DDEBUG --verbose&quot;. The standy database is able to promote to be the=
 primary. For the previous primary database, it was shutdown. It was not ab=
le to bring up as standby by repmgr. =C2=A0<br><br>Does anyone encounter th=
is issue before? Thanks a lot for any suggestions.<br><br>Here is my OS and=
 DB versions:<br><br>OS version: CentOS Stream release 8<br>Postgres DB ver=
sion: =C2=A015.12<br>rempmgr version: 5.5.0<br><br>Here is the repmgr conf =
files:<br>&gt;&gt;&gt;&gt;&gt;<br>node_id=3D1 =C2=A0# Use 2 on standby<br>n=
ode_name=3D&#39;primary&#39;<br>conninfo=3D&#39;host=3Dcentos804 user=3Drep=
mgr dbname=3Drepmgr password=3Dxxx connect_timeout=3D15&#39;<br>use_primary=
_conninfo_password=3Dtrue<br>data_directory=3D&#39;/var/lib/pgsql/15/data&#=
39; =C2=A0# Adjust for your setup<br>pg_bindir=3D&#39;/usr/pgsql-15/bin&#39=
;<br>service_start_command =3D &#39;sudo systemctl start postgresql-15&#39;=
<br>service_stop_command =C2=A0=3D &#39;sudo systemctl stop postgresql-15&#=
39;<br>&lt;&lt;&lt;&lt;&lt;<br><br>&gt;&gt;&gt;&gt;&gt;<br>node_id=3D2 =C2=
=A0# Use 2 on standby<br>node_name=3D&#39;standby&#39;<br>conninfo=3D&#39;h=
ost=3Dcentos803 user=3Drepmgr dbname=3Drepmgr password=3Dxxx connect_timeou=
t=3D15&#39;<br>use_primary_conninfo_password=3Dtrue<br>data_directory=3D=
9;/var/lib/pgsql/15/data&#39; =C2=A0# Adjust for your setup<br>pg_bindir=3D=
&#39;/usr/pgsql-15/bin&#39;<br>service_start_command =3D &#39;sudo systemct=
l start postgresql-15&#39;<br>service_stop_command =C2=A0=3D &#39;sudo syst=
emctl stop postgresql-15&#39;<br>&lt;&lt;&lt;&lt;&lt;<br><br>Regards,<br>Ch=
ris<br></div>
</blockquote></div></div></div>
</blockquote></div>

--000000000000755a9f0640161c24--