↑↓ select ↵ open ⌫ change scope Open full search

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

Functions / System Administration Functions

pg_switch_xlog

Read the PG 9.6 manual

Force switch to a new transaction log file (restricted to superusers by default, but other users can be granted EXECUTE to run the function)

Reading PG 9.6·documented in 10 of 27 versions, 8.2 to 9.6

7.17.27.37.48.08.18.28.38.49.09.19.29.39.49.59.61011121314151617181920

Historical documentation for a PostgreSQL version that is no longer supported.

Signatures & examples

pg_switch_xlog ( ) → pg_lsn
Force switch to a new transaction log file (restricted to superusers by default, but other users can be granted EXECUTE to run the function)
Version history 5
  1. 9.6 → 10 removed
  2. 9.5 → 9.6 changed
  3. 9.3 → 9.4 changed
  4. 9.0 → 9.1 changed
  5. 8.1 → 8.2 added

Definition snapshot: b7bd9cda · English manual source