On Wed, 26 Jul 2017 at 7:56 pm, B A, Ramaswamy < ramaswamy...@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