Functions / System Administration Functions

pg_switch_wal

Forces the server to switch to a new write-ahead log file, which allows the current file to be archived (assuming you are using continuous archiving).

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

7.1 7.2 7.3 7.4 8.0 8.1 8.2 8.3 8.4 9.0 9.1 9.2 9.3 9.4 9.5 9.6 10 11 12 13 14 15 16 17 18 19 20

Signatures & examples

pg_switch_wal () → pg_lsn

Forces the server to switch to a new write-ahead log file, which allows the current file to be archived (assuming you are using continuous archiving). The result is the ending write-ahead log location plus 1 within the just-completed write-ahead log file. If there has been no write-ahead log activity since the last write-ahead log switch, pg_switch_wal does nothing and returns the start location of the write-ahead log file currently in use.

Version history 2

12 → 13 changed
9.6 → 10 added

Definition snapshot: b7bd9cda · English manual source