--停止
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;
--再開
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION;
STOP SLAVE;
STOP SLAVE IO_THREAD;
STOP SLAVE SQL_THREAD;
show slave status \G
START SLAVE;
START SLAVE IO_THREAD;
START SLAVE SQL_THREAD;
(9.4)(9.6)
--リカバリ停止中の確認
select pg_is_xlog_replay_paused();
--リカバリ一時停止
select pg_xlog_replay_pause();
--リカバリ再開
select pg_xlog_replay_resume();
(10)
--リカバリ停止中の確認
select pg_is_wal_replay_paused();
--リカバリ一時停止
select pg_wal_replay_pause();
--リカバリ再開
select pg_wal_replay_resume();
ALTER DATABASE [testdb] SET HADR SUSPEND;
GO
ALTER DATABASE [testdb] SET HADR RESUME;
GO