Pause and Resume Replication

To pause and resume postgres replication from the slave, you can execute the following.

# pause replication
psql -c "select pg_xlog_replay_pause();"
 
# resume replication
psql -c "select pg_xlog_replay_resume();"
(Comments)

Comments