Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1v3u6X-005Okn-A5 for pgsql-admin@arkaria.postgresql.org; Wed, 01 Oct 2025 10:30:37 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1v3u6V-000c5o-AJ for pgsql-admin@arkaria.postgresql.org; Wed, 01 Oct 2025 10:30:35 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1v3u6U-000c5f-RZ for pgsql-admin@lists.postgresql.org; Wed, 01 Oct 2025 10:30:35 +0000 Received: from mail-yx1-xb12f.google.com ([2607:f8b0:4864:20::b12f]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1v3u6T-0013qP-1Q for pgsql-admin@postgresql.org; Wed, 01 Oct 2025 10:30:35 +0000 Received: by mail-yx1-xb12f.google.com with SMTP id 956f58d0204a3-6352c8b683eso8054868d50.2 for ; Wed, 01 Oct 2025 03:30:33 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1759314632; x=1759919432; darn=postgresql.org; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=9gN87i7BVRP80v054ob2TXc3uXMC59y9Xk2Q3oUkJHs=; b=bP0LlkXdAGAS6vjmuYlQ2geJ9GBR6ojENu7wM1oVxVzO2JdaO2/6ht58vEklqohOV/ XIsdgNGnyCgz8bPbhw7bUs++hJbFbN96ahC9rMJCPO/63l2NT6W/yIOCvFFDM22QrL56 qe3LEkJ5nCGosob7a4LFuAWCZ46rQy+DkGBRW45pCYvieJG1s3mNVv1fQrT8QM5CWQF9 VI8S85E0kGa5YvZ2vSU2Rkaw5nh5G5uCPvjO+itgpP6YuYz1IMRIHxdchW40I2b6NL0K D+f+rNlXLgCqQTkFq1B47GOLsyX2q+adbHITDDIi9zFORRokcLEOh9zHmc7z5+x0zBKe 7xTQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1759314632; x=1759919432; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:x-gm-message-state:from:to:cc:subject:date:message-id :reply-to; bh=9gN87i7BVRP80v054ob2TXc3uXMC59y9Xk2Q3oUkJHs=; b=SOxVoxaVC1jFv6P5wyNZBxWwk8z3JcL3h6H6jXqx/y6dhuD/sL63fauTThhAjTqXec ddu99D2/kkzyaPo/qdH4ABJfKoREnhPZ2Z18mJeTN6cyWPrY412rCgW4RdfplaHSxdCf Xe/jRDiN7qlhDJ3blI5leOuiUXJOifLNPswk6MDmUFhEWu80BQBpMVxpXDHSD8koCn8v LRJCn5lQZk4RcNAzc+Vn+hnsPIfqK99pMvYE1/MBqL/WSMSouc9vTtErHMYzUjzSBJPo wnpb2CXBexZQwnd5SbLRJ5fP7rXzFVIIUCkIL3BjNHd4EG/2BGXP9/Z8ssVof39BMKix FviA== X-Gm-Message-State: AOJu0YyyunXMTnsttEaeUcJ47seWrEEUeXFi0Orw+5FCns0zpIB53oHo y/u25cAZM/8QPbVIyJeYD4FtP99Yxvvmp5SyG7ODC2Z5JHUV+wVxPMsHRBVf+xCu9/DQqA/g7tN 2NYsMknGBdTH43+SC8br+cPU0zi7HFVR3IaIA X-Gm-Gg: ASbGncv+lNPjIboESteKIDtMxH0yhtEQpLw6295Kre5l5KZNbWdNaklxtQ3Ls0cHr3y 7VTfQIFeS/CK8Hy4jkRLos6DoE0fi3BA7LxpiW8kmGiEu3zdZd3tZbcrSZJgljcler/i1A3mh4F 1px9NkZK08SETVJZXvoNg7rnZDL6W/Knvd7pHRdQF2AU4+4rF4yWFB9L7ZtslcJtt2mlOWvEeDs OHzvb56L8uz2PJwehYH/dZElyqKgLI= X-Google-Smtp-Source: AGHT+IFCpChUyojORQ/kShXgeRtKo82xFBP2hAtOhU1QinIoZvqCa19r0LD6OWrIdwW6/CN2PMfQAi6w/Pdb8uKC860= X-Received: by 2002:a53:840c:0:b0:635:4ecd:759c with SMTP id 956f58d0204a3-63b70099ademr2715367d50.42.1759314631724; Wed, 01 Oct 2025 03:30:31 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: Chris Lee Date: Wed, 1 Oct 2025 18:30:20 +0800 X-Gm-Features: AS18NWA2EoNvDZdNdqgNhhUBmX-5X2awqDh-sAsSyFH8wV1pk27irvWc8evIRpw Message-ID: Subject: Re: repmgr cannot bring up the standby database after switchover manaully To: Imran Khan , Tayyab Fayyaz Cc: pgsql-admin Content-Type: multipart/alternative; boundary="000000000000ac14eb0640165b79" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000ac14eb0640165b79 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable Hi Tayyab, Thanks for your information . I also want to find out whether that is the default behavior, or I am not configuring repmgr correctly. Regards, Chris On Wed, 1 Oct 2025, 18:12 Imran Khan, wrote: > 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 > 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, 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. F= or >>> the previous primary database, it was shutdown. It was not able to brin= g 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=3Dx= xx >>> 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=3Dx= xx >>> 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 >>> >> --000000000000ac14eb0640165b79 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Hi Tayyab,

T= hanks for your information . I also want to find out whether that is the de= fault behavior,=C2=A0 or I am not configuring repmgr correctly.

Regards,
Chr= is

On Wed, 1 Oct 2025, 18:12 Imran Khan, <imran.k.23@gmail.com> wrote:
Hi Tayyab,

=C2=A0Is this a default behavior? We = have 4 nodes cluster but never had issue in switchovers.=C2=A0

Thanks,=C2=A0
Imran

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

I faced this issue it will not add automatically as standby you h= ave to add it manually.

= But I wrote a script which perform to add old primary as standby once it= 9;s back online.

Tayyab<= /div>

On Wed, 1 Oct 2025, 3:02=E2=80=AFpm Chris Lee, <clee.hk@gma= il.com> wrote:
Hi all,

I have 2 postgresql servers. One is the primary and anot= her one is the standby. I am trying to setup repmgr to do the switchover ma= nually. Passwordless ssh have been setup for postgres ID on both servers.
I use this command "repmgr standby switchover --log-level=3DDEBU= G --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 br= ing up as standby by repmgr. =C2=A0

Does anyone encounter this issue= before? Thanks a lot for any suggestions.

Here is my OS and DB vers= ions:

OS version: CentOS Stream release 8
Postgres DB version: = =C2=A015.12
rempmgr version: 5.5.0

Here is the repmgr conf files:=
>>>>>
node_id=3D1 =C2=A0# Use 2 on standby
node_na= me=3D'primary'
conninfo=3D'host=3Dcentos804 user=3Drepmgr db= name=3Drepmgr password=3Dxxx connect_timeout=3D15'
use_primary_conni= nfo_password=3Dtrue
data_directory=3D'/var/lib/pgsql/15/data' = =C2=A0# Adjust for your setup
pg_bindir=3D'/usr/pgsql-15/bin'service_start_command =3D 'sudo systemctl start postgresql-15'
= service_stop_command =C2=A0=3D 'sudo systemctl stop postgresql-15'<= br><<<<<

>>>>>
node_id=3D2 =C2=A0# = 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' =C2=A0# Adjust for your setup
pg_bindir=3D&= #39;/usr/pgsql-15/bin'
service_start_command =3D 'sudo systemctl= start postgresql-15'
service_stop_command =C2=A0=3D 'sudo syste= mctl stop postgresql-15'
<<<<<

Regards,
Chr= is
--000000000000ac14eb0640165b79--