Contents
pg_replication_origin_drop()
A function for removing a replication origin
pg_replication_origin_drop()
is a system function for removing a replication origin.
pg_replication_origin_drop()
was added in PostgreSQL 9.5.
Usage
pg_replication_origin_drop (node_name
text
) →void
The replication origin's entry will be removed from pg_replication_origin
and associated replay progress will be removed.
Change history
- PostgreSQL 9.5
- added (commit 5aa23504)
Examples
Basic usage example for pg_replication_origin_drop()
:
postgres=# SELECT pg_replication_origin_drop('foo'); pg_replication_origin_drop ---------------------------- (1 row)
Attempting to drop a non-existent replication origin:
postgres=# SELECT pg_replication_origin_drop('bar'); ERROR: replication origin "bar" does not exist
References
- PostgreSQL documentation: Replication Management Functions