Promoting Hot standby after running select pg_xlog_replay_pause();
От | Bellrose, Brian |
---|---|
Тема | Promoting Hot standby after running select pg_xlog_replay_pause(); |
Дата | |
Msg-id | BN7PR07MB4178842E599C388A7A3C41DDE7CC0@BN7PR07MB4178.namprd07.prod.outlook.com обсуждение исходный текст |
Ответы |
Re: Promoting Hot standby after running select pg_xlog_replay_pause();
|
Список | pgsql-general |
I have a scenario where we are doing an application release and they want to be able to potentially rollback to HA if things go bad. So the current process would be:
- Run select pg_xlog_replay_pause(); on standby to pause replication
- Apply changes
- If team needs to revert to older version of cluster we would run pg_ctl promote
My question is, would pg_ctl prmote start up from the point where replication was paused or would it try and sync before it opens? Thus applying all the changes I am trying to prevent?
Thanks,
Brian
В списке pgsql-general по дате отправления: