Last Updated: February 25, 2016
·
17.04K
· ccastillo

Pause and resume hot_standby replication on Postgres database

To pause, run the following query on the slave server:

select pg_xlog_replay_pause();

To resume, run
select pg_xlog_replay_resume();