A system function for marking an on-line backup as completed
This entry relates to a PostgreSQL feature which is deprecated and may be desupported in future releases.

pg_stop_backup() is a system function for marking a exclusive or non-exclusive on-line backup as completed.

pg_stop_backup() was introduced in PostgreSQL 8.0 and replaced in PostgreSQL 15 by pg_backup_stop().


pg_stop_backup ( exclusive boolean [, wait_for_archive boolean ] ) →
        setof record ( lsn pg_lsn, labelfile text, spcmapfile text )

Change history


Backup, Deprecated, Replication, System function

See also

pg_start_backup(), pg_is_in_backup(), pg_backup_start_time(), Backup history file, backup_label, tablespace_map