PostgreSQL switchover process

From: rams nalabolu <ramsveeru441(at)gmail(dot)com>
To: pgsql-docs(at)lists(dot)postgresql(dot)org
Subject: PostgreSQL switchover process
Date: 2020-08-24 19:56:43
Message-ID: CAHq7gtAW9CPeKsjxdHfJRvs=9==C8od1M4-fbxw+jgvRc9VE=w@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

Responses

Browse pgsql-docs by date

  From Date Subject
Next Message Stephen Frost 2020-08-24 20:00:09 Re: Openssl v3_ca
Previous Message Bruce Momjian 2020-08-24 17:56:53 Openssl v3_ca