Alternative Method for Log Shipping
25.4. Alternative Method for Log Shipping
An alternative to the built-in standby mode described in the previous sections is to use a restore_command
that polls the archive location. This was the only option available in versions 8.4 and below. In this setup, set standby_mode
off, because you are implementing the polling required for standby operation yourself. See the pg_standby module for a reference implementation of this.
Note that in this mode, the server will apply WAL one file at a time, so if you use the standby server for queries (see Hot Standby), there is a delay between an action in the master and when the action becomes visible in the standby, corresponding the time it ta