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();
Written by Cristóbal Castillo
Related protips
Have a fresh tip? Share with Coderwall community!
Post
Post a tip
Best
#Postgres
Authors
Sponsored by #native_company# — Learn More
#native_title#
#native_desc#