Browse categories
Random entry
PostgreSQL releases
- PostgreSQL 16 (dev)
- PostgreSQL 15 (latest)
- PostgreSQL 14
- PostgreSQL 13
- PostgreSQL 12
- PostgreSQL 11
- PostgreSQL 10 (EOL)

Version charts

SQL commands
System catalog tables
System catalog views
System statistics views
File system functions

Contrib modules
Object Identifier Types
Progress reporting views
Storage parameters (relopts)

Useful overviews

xlog renaming in Pg 10
Online tools for PostgreSQL
Abbreviations and acronyms

Useful links

PostgreSQL documentation
PostgreSQL feature matrix
PostgreSQL versioning policy
PostgreSQL latest versions

@postgrespedia

Contents

Usage
Change history
References
Categories
See also

pg_stop_backup()

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().

Usage

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

Change history

PostgreSQL 15
- replaced by pg_backup_stop() (commit 39969e2a)
PostgreSQL 10
- option wait_for_archive boolean added (commit 017e4f25)
PostgreSQL 9.6
- option exclusive boolean providing support for non-exclusive backups added (commit 71176854)
PostgreSQL 9.4
- return value type changed from text to pg_lsn (commit 6f289c2b)
PostgreSQL 8.0
- added (commit 58c41712)

References

PostgreSQL documentation: Backup Control Functions

Categories

See also

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