MIME-Version: 1.0
References: 
 <CAP0GqH7hYsFGmLg3Ge-_Lf_VEeES8yeHpOhSvn071=XRnmVxTw@mail.gmail.com>
In-Reply-To: 
 <CAP0GqH7hYsFGmLg3Ge-_Lf_VEeES8yeHpOhSvn071=XRnmVxTw@mail.gmail.com>
From: Tayyab Fayyaz <tayyab.humayl@gmail.com>
Date: Wed, 1 Oct 2025 15:09:37 +0500
Message-ID: 
 <CAFVRaQ3No2rEYjkuKsxNNMCP16_J_kjDm_pv0+CYwTLXsjE8OQ@mail.gmail.com>
Subject: Re: repmgr cannot bring up the standby database after switchover
 manaully
To: Chris Lee <clee.hk@gmail.com>
Cc: pgsql-admin@postgresql.org
Content-Type: multipart/alternative; boundary="00000000000090f6060640161109"
Archived-At: 
 <https://www.postgresql.org/message-id/CAFVRaQ3No2rEYjkuKsxNNMCP16_J_kjDm_pv0%2BCYwTLXsjE8OQ%40mail.gmail.com>
Precedence: bulk

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

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. For
> 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 suggestions=
.
>
> 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=3Dxxx
> 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=3Dxxx
> 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
>

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

<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 automatically 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 dir=3D"auto">Tayyab</div=
><br><br><div class=3D"gmail_quote gmail_quote_container"><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">clee.hk@gmail.com</a>&gt; wrote:<br></div=
><blockquote class=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:1=
px #ccc solid;padding-left:1ex"><div dir=3D"ltr">Hi all,<br><br>I have 2 po=
stgresql servers. One is the primary and another one is the standby. I am t=
rying to setup repmgr to do the switchover manually. Passwordless ssh have =
been setup for postgres ID on both servers.<br><br>I use this command &quot=
;repmgr standby switchover --log-level=3DDEBUG --verbose&quot;. The standy =
database is able to promote to be the primary. For the previous primary dat=
abase, it was shutdown. It was not able to bring up as standby by repmgr. =
=C2=A0<br><br>Does anyone encounter this issue before? Thanks a lot for any=
 suggestions.<br><br>Here is my OS and DB versions:<br><br>OS version: Cent=
OS Stream release 8<br>Postgres DB version: =C2=A015.12<br>rempmgr version:=
 5.5.0<br><br>Here is the repmgr conf files:<br>&gt;&gt;&gt;&gt;&gt;<br>nod=
e_id=3D1 =C2=A0# Use 2 on standby<br>node_name=3D&#39;primary&#39;<br>conni=
nfo=3D&#39;host=3Dcentos804 user=3Drepmgr dbname=3Drepmgr password=3Dxxx co=
nnect_timeout=3D15&#39;<br>use_primary_conninfo_password=3Dtrue<br>data_dir=
ectory=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;s=
udo 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>&g=
t;&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;host=3Dcentos803 user=3Drepmgr 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>servi=
ce_start_command =3D &#39;sudo systemctl start postgresql-15&#39;<br>servic=
e_stop_command =C2=A0=3D &#39;sudo systemctl stop postgresql-15&#39;<br>&lt=
;&lt;&lt;&lt;&lt;<br><br>Regards,<br>Chris<br></div>
</blockquote></div></div></div>

--00000000000090f6060640161109--