PostgreSQL switchover process - Mailing list pgsql-docs

From rams nalabolu
Subject PostgreSQL switchover process
Date
Msg-id CAHq7gtAW9CPeKsjxdHfJRvs=9==C8od1M4-fbxw+jgvRc9VE=w@mail.gmail.com
Whole thread Raw
Responses Re: PostgreSQL switchover process  (Michael Paquier <michael@paquier.xyz>)
List pgsql-docs
Hi All,

I'm trying to do the Switchover process in postgres.
1) I have my primary cluster running on port 5432 on server A
2)  secondary cluster on the port 5432 on server B
I did setup streaming replication b/w primary and secondary using replication slots.

I did the following steps to perform switchover
1) ran a checkpoint on primary.
2) verified secondary status and it is up to date with primary.
3) stopped primary using pg_ctl -mf i.e force.
4) promoted primary using trigger file and verified the status of the new primary; it is not in recovery mode and running on new timeline ID 2.
5) I did create the recovery.conf file on old primary i.e new standby with 
      primaray_coninfo: new primary(B)
      recovery_target_timeline='latest'
      primary_slot_name: "slot I created in new_standby"
6) I started the new standby. It is up and running but it is not in recovery mode.

But the wal sender process on primary and receiver process on secondary are not running. i.e it looks like my replication is broken.
what steps am I missing here without rebuilding a new standby i.e old primary I want the replication happen b/w my new primary and secondary.

Could you suggest any good documentation?

thanks in advance.

Thanks,
Veeru.
 
 



pgsql-docs by date:

Previous
From: Bruce Momjian
Date:
Subject: Openssl v3_ca
Next
From: Stephen Frost
Date:
Subject: Re: Openssl v3_ca