Re: Postgres Replication Switchback to master in Postgres-9.6 - Mailing list pgadmin-support

From Venkata B Nagothi
Subject Re: Postgres Replication Switchback to master in Postgres-9.6
Date
Msg-id CAEyp7J8d7aPZPqP0PWB++rY8-_mb2cUSPkUyYmPo7A6TETWoeA@mail.gmail.com
Whole thread Raw
In response to Postgres Replication Switchback to master in Postgres-9.6  ("B A, Ramaswamy " <ramaswamy.ba@credit-suisse.com>)
List pgadmin-support

On Wed, 26 Jul 2017 at 7:56 pm, B A, Ramaswamy <ramaswamy.ba@credit-suisse.com> wrote:

Hi Team

 

I  have setup the Postgres  Hot Standby  with streaming replication with help  of pg_basebackup

I need a help  on switback to old master as master server.

Switchover on Failover

On Failover I am able to make Standby to become primary and continue with command “pg_ctl promot”

Found it is easy process

Switchback

Case, want to switch back old master as  Master server and  move the new Master one as Standby Server.

-          Master is down

-          Promoted slave as master

-          Inserted few records

-          Need to demote the Slave and bring back the Master

What is the correct procedure to sync data between Slave and newly started Master

Is it same process should follow while creating standby?

 

 

Thanks in advance,  your reply will greatly help


This email is supposed to be sent to pgsql general mailing list.

.

 

Thanks and Regards

Ramaswamy B.A



==============================================================================
Please access the attached hyperlink for an important electronic communications disclaimer:
http://www.credit-suisse.com/legal/en/disclaimer_email_ib.html
==============================================================================

--

Regards,

Venkata B N
Database Consultant
 

pgadmin-support by date:

Previous
From: Murtuza Zabuawala
Date:
Subject: Re: Running development version of pgAdmin 4 corrupts the configuration
Next
From: Pawel Hadam
Date:
Subject: Re: pgAdmin 4 v1.6 Released!