↑↓ select ↵ open ⌫ change scope Open full search

PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.

Functions / System Administration Functions

pg_wal_replay_pause

Read the PG 18 manual

Request to pause recovery.

Reading PG 18current·documented in 11 of 27 versions, 10 to 20

Signatures & examples

pg_wal_replay_pause () → void
Request to pause recovery. A request doesn't mean that recovery stops right away. If you want a guarantee that recovery is actually paused, you need to check for the recovery pause state returned by pg_get_wal_replay_pause_state(). Note that pg_is_wal_replay_paused() returns whether a request is made. While recovery is paused, no further database changes are applied. If hot standby is active, all new queries will see the same consistent snapshot of the database, and no further query conflicts will be generated until recovery is resumed.
Version history 3
  1. 13 → 14 changed
  2. 12 → 13 changed
  3. 9.6 → 10 added

Definition snapshot: b7bd9cda · English manual source