PostgreSQL switchover process

Поиск
Список
Период
Сортировка
От rams nalabolu
Тема PostgreSQL switchover process
Дата
Msg-id CAHq7gtAW9CPeKsjxdHfJRvs=9==C8od1M4-fbxw+jgvRc9VE=w@mail.gmail.com
обсуждение исходный текст
Ответы Re: PostgreSQL switchover process  (Michael Paquier <michael@paquier.xyz>)
Список 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 по дате отправления:

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Openssl v3_ca
Следующее
От: Stephen Frost
Дата:
Сообщение: Re: Openssl v3_ca