public inbox for [email protected]  

help / color / mirror / Atom feed

From: Tayyab Fayyaz <[email protected]>
To: Chris Lee <[email protected]>
Cc: [email protected]
Subject: Re: repmgr cannot bring up the standby database after switchover manaully
Date: Wed, 1 Oct 2025 15:09:37 +0500
Message-ID: <CAFVRaQ3No2rEYjkuKsxNNMCP16_J_kjDm_pv0+CYwTLXsjE8OQ@mail.gmail.com> (raw)
In-Reply-To: <CAP0GqH7hYsFGmLg3Ge-_Lf_VEeES8yeHpOhSvn071=XRnmVxTw@mail.gmail.com>
References: <CAP0GqH7hYsFGmLg3Ge-_Lf_VEeES8yeHpOhSvn071=XRnmVxTw@mail.gmail.com>

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 pm Chris Lee, <[email protected]> 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=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
>

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected]
  Subject: Re: repmgr cannot bring up the standby database after switchover manaully
  In-Reply-To: <CAFVRaQ3No2rEYjkuKsxNNMCP16_J_kjDm_pv0+CYwTLXsjE8OQ@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox