Postgres Pro
Downloads
Home   >   mailing lists

Re: Failover and Failback - Mailing list pgsql-admin

From sethu mathavan
Subject Re: Failover and Failback
Date
Msg-id CAO9pKO1-P1JRqs_0UpEGYiur7cMUev4zvbJqKqNV391VNFPP3A@mail.gmail.com
Whole thread Raw
In response to Failover and Failback  ("Narendran .j" <jnarendran3@gmail.com>)
List pgsql-admin
Tree view

Hi Narendran,

Before running rewind command,need to change few parameters in postgresql.conf file.like primary_conninfo in old_master.

Regards,
Sethu

On Thu, 19 Sep, 2024, 4:46 pm Narendran .j, <jnarendran3@gmail.com> wrote:
Hello Team,

I have facing a problem in failback. I just promoted my secondary as master by using pg_ctl promote.it was successful.so now how can I bring my old master as primary I tried with pg_rewind it's not working. So is there any other way to perform failback. Is there any procedure to perform failback and failover please share with me. Additionally we don't use any tool for it.

Regards 
Narendran J

pgsql-admin by date:

Previous
From: Michael Banck
Date:
Subject: Re: Failover and Failback
Next
From: Sunil Jadhav
Date:
Subject: How to make superuser from non superuser in PostgreSQL