Contents
pg_replication_origin_create()
A function for creating a replication origin
pg_replication_origin_create() is a system function for creating a replication origin.
pg_replication_origin_create() was added in PostgreSQL 9.5.
Usage
pg_replication_origin_create (node_nametext) →oid
This function creates an entry with the provided node_name in pg_replication_origin and returns the OID of the entry.
Change history
- PostgreSQL 9.5
- added (commit 5aa23504)
Examples
Basic usage example for pg_replication_origin_create():
postgres=# SELECT pg_replication_origin_create('foo');
pg_replication_origin_create
------------------------------
1
(1 row)
It is not possible to create a replication origin with a duplicate name:
postgres=# SELECT pg_replication_origin_create('foo');
ERROR: duplicate key value violates unique constraint "pg_replication_origin_roname_index"
DETAIL: Key (roname)=(foo) already exists.
References
- PostgreSQL documentation: Replication Management Functions