MIME-Version: 1.0
From: Chris Lee <clee.hk@gmail.com>
Date: Wed, 1 Oct 2025 18:02:02 +0800
Message-ID: 
 <CAP0GqH7hYsFGmLg3Ge-_Lf_VEeES8yeHpOhSvn071=XRnmVxTw@mail.gmail.com>
Subject: repmgr cannot bring up the standby database after switchover manaully
To: pgsql-admin@postgresql.org
Content-Type: multipart/alternative; boundary="0000000000006c9393064015f614"
Archived-At: 
 <https://www.postgresql.org/message-id/CAP0GqH7hYsFGmLg3Ge-_Lf_VEeES8yeHpOhSvn071%3DXRnmVxTw%40mail.gmail.com>
Precedence: bulk

--0000000000006c9393064015f614
Content-Type: text/plain; charset="UTF-8"

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=DEBUG --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=1  # Use 2 on standby
node_name='primary'
conninfo='host=centos804 user=repmgr dbname=repmgr password=xxx
connect_timeout=15'
use_primary_conninfo_password=true
data_directory='/var/lib/pgsql/15/data'  # Adjust for your setup
pg_bindir='/usr/pgsql-15/bin'
service_start_command = 'sudo systemctl start postgresql-15'
service_stop_command  = 'sudo systemctl stop postgresql-15'
<<<<<

>>>>>
node_id=2  # Use 2 on standby
node_name='standby'
conninfo='host=centos803 user=repmgr dbname=repmgr password=xxx
connect_timeout=15'
use_primary_conninfo_password=true
data_directory='/var/lib/pgsql/15/data'  # Adjust for your setup
pg_bindir='/usr/pgsql-15/bin'
service_start_command = 'sudo systemctl start postgresql-15'
service_stop_command  = 'sudo systemctl stop postgresql-15'
<<<<<

Regards,
Chris

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

<div dir=3D"ltr">Hi all,<br><br>I have 2 postgresql servers. One is the pri=
mary 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 bo=
th servers.<br><br>I use this command &quot;repmgr standby switchover --log=
-level=3DDEBUG --verbose&quot;. The standy database is able to promote to b=
e the primary. For the previous primary database, it was shutdown. It was n=
ot able to bring up as standby by repmgr. =C2=A0<br><br>Does anyone encount=
er this issue before? Thanks a lot for any suggestions.<br><br>Here is my O=
S and DB versions:<br><br>OS version: CentOS Stream release 8<br>Postgres D=
B 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>node_id=3D1 =C2=A0# Use 2 on standby=
<br>node_name=3D&#39;primary&#39;<br>conninfo=3D&#39;host=3Dcentos804 user=
=3Drepmgr dbname=3Drepmgr password=3Dxxx connect_timeout=3D15&#39;<br>use_p=
rimary_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/b=
in&#39;<br>service_start_command =3D &#39;sudo systemctl start postgresql-1=
5&#39;<br>service_stop_command =C2=A0=3D &#39;sudo systemctl stop postgresq=
l-15&#39;<br>&lt;&lt;&lt;&lt;&lt;<br><br>&gt;&gt;&gt;&gt;&gt;<br>node_id=3D=
2 =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_t=
imeout=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_bin=
dir=3D&#39;/usr/pgsql-15/bin&#39;<br>service_start_command =3D &#39;sudo sy=
stemctl start postgresql-15&#39;<br>service_stop_command =C2=A0=3D &#39;sud=
o systemctl stop postgresql-15&#39;<br>&lt;&lt;&lt;&lt;&lt;<br><br>Regards,=
<br>Chris<br></div>

--0000000000006c9393064015f614--