↑↓ select ↵ open ⌫ change scope Open full search

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

Functions / System Administration Functions

pg_stop_backup

Read the PG 14 manual

Finishes performing an exclusive or non-exclusive on-line backup.

Reading PG 14·documented in 17 of 27 versions, 8.0 to 14

Signatures & examples

pg_stop_backup ( exclusive boolean [, wait_for_archive boolean ] ) → setof record ( lsn pg_lsn, labelfile text, spcmapfile text )
Finishes performing an exclusive or non-exclusive on-line backup. The exclusive parameter must match the previous pg_start_backup call. In an exclusive backup, pg_stop_backup removes the backup label file and, if it exists, the tablespace map file created by pg_start_backup. In a non-exclusive backup, the desired contents of these files are returned as part of the result of the function, and should be written to files in the backup area (not in the data directory).
pg_stop_backup () → pg_lsn
Finishes performing an exclusive on-line backup. This simplified version is equivalent to pg_stop_backup(true, true), except that it only returns the pg_lsn result.
Version history 7
  1. 14 → 15 removed
  2. 12 → 13 changed
  3. 9.6 → 10 changed
  4. 9.5 → 9.6 changed
  5. 9.3 → 9.4 changed
  6. 9.0 → 9.1 changed
  7. 7.4 → 8.0 added

Definition snapshot: b7bd9cda · English manual source