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

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

Categories

Logical replication, System function

See also

pg_replication_origin_create(), pg_replication_origin