MIME-Version: 1.0
References: 
 <CAP0GqH7hYsFGmLg3Ge-_Lf_VEeES8yeHpOhSvn071=XRnmVxTw@mail.gmail.com>
In-Reply-To: 
 <CAP0GqH7hYsFGmLg3Ge-_Lf_VEeES8yeHpOhSvn071=XRnmVxTw@mail.gmail.com>
From: Imran Khan <imran.k.23@gmail.com>
Date: Wed, 1 Oct 2025 13:06:33 +0300
Message-ID: 
 <CAC4eXDj6VOYSYfqNrvMc-PveoVTxjVY4uBnF_ZJgNLkJtQZLNQ@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 <pgsql-admin@postgresql.org>
Content-Type: multipart/alternative; boundary="0000000000009111a20640160664"
Archived-At: 
 <https://www.postgresql.org/message-id/CAC4eXDj6VOYSYfqNrvMc-PveoVTxjVY4uBnF_ZJgNLkJtQZLNQ%40mail.gmail.com>
Precedence: bulk

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

Hi Chris,

Why are you risking by having only two node repmgr setup? Why not 3 nodes?

Thanks,
Imran

On Wed, Oct 1, 2025, 1: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
>

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

<div dir=3D"auto">Hi Chris,<div dir=3D"auto"><br></div><div dir=3D"auto">Wh=
y are you risking by having only two node repmgr setup? Why not 3 nodes?</d=
iv><div dir=3D"auto"><br></div><div dir=3D"auto">Thanks,=C2=A0</div><div di=
r=3D"auto">Imran</div></div><br><div class=3D"gmail_quote gmail_quote_conta=
iner"><div dir=3D"ltr" class=3D"gmail_attr">On Wed, Oct 1, 2025, 1: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: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 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 --ver=
bose&quot;. The standy database is able to promote to be the primary. For t=
he previous primary database, 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:<b=
r><br>OS version: CentOS 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>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=3Dre=
pmgr password=3Dxxx connect_timeout=3D15&#39;<br>use_primary_conninfo_passw=
ord=3Dtrue<br>data_directory=3D&#39;/var/lib/pgsql/15/data&#39; =C2=A0# Adj=
ust for your setup<br>pg_bindir=3D&#39;/usr/pgsql-15/bin&#39;<br>service_st=
art_command =3D &#39;sudo systemctl start postgresql-15&#39;<br>service_sto=
p_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 st=
andby<br>node_name=3D&#39;standby&#39;<br>conninfo=3D&#39;host=3Dcentos803 =
user=3Drepmgr dbname=3Drepmgr password=3Dxxx connect_timeout=3D15&#39;<br>u=
se_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 postgres=
ql-15&#39;<br>service_stop_command =C2=A0=3D &#39;sudo systemctl stop postg=
resql-15&#39;<br>&lt;&lt;&lt;&lt;&lt;<br><br>Regards,<br>Chris<br></div>
</blockquote></div>

--0000000000009111a20640160664--