Re: Promoting Hot standby after running select pg_xlog_replay_pause();

2020-03-27 Thread Jerry Sievers
"Bellrose, Brian" writes: > 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: > > > > 1. Run select pg_xlog_replay_pause(); on standby to pause > replication > 2. Apply

Promoting Hot standby after running select pg_xlog_replay_pause();

2020-03-27 Thread Bellrose, Brian
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: 1. Run select pg_xlog_replay_pause(); on standby to pause replication 2. Apply changes 3. If team needs to revert to old