May 2018
Intermediate to advanced
576 pages
30h 25m
English
Normally, a standby will apply changes as soon as possible. When you set the recovery_min_apply_delay parameter in recovery.conf, the application of commit records will be delayed by the specified duration. Note that only commit records are delayed, so you may receive Hot Standby cancellations using this feature. You can prevent that by setting hot_standby_feedback to on, but use this with caution, since it can cause significant bloat on a busy master if recovery_min_apply_delay is large.
If something bad happens, then hit the pause button.
Hot Standby allows you to pause and resume replay of change:
SELECT pg_wal_replay_pause();
Once paused, all queries will receive the same snapshot, ...