select open change scope Open full search

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

FUNCTIONS / SYSTEM ADMINISTRATION FUNCTIONS

pg_start_backup

Read PG 14 manual ↗

Prepares the server to begin an on-line backup.

Signatures & examples

pg_start_backup ( label text [, fast boolean [, exclusive boolean ]] ) → pg_lsn
Prepares the server to begin an on-line backup. The only required parameter is an arbitrary user-defined label for the backup. (Typically this would be the name under which the backup dump file will be stored.) If the optional second parameter is given as true, it specifies executing pg_start_backup as quickly as possible. This forces an immediate checkpoint which will cause a spike in I/O operations, slowing any concurrently executing queries. The optional third parameter specifies whether to perform an exclusive or non-exclusive backup (default is exclusive).
Version history 5
  1. PG 14 → 15removed
  2. PG 12 → 13changed
  3. PG 9.5 → 9.6changed
  4. PG 9.3 → 9.4changed
  5. PG 9.0 → 9.1changed

Definition snapshot: 2026-09-14T13:14:25.684213+00:00@99e6866c · English manual source