pg_replication_origin
A system table storing all replication origins created
pg_replication_origin is a system catalogue table storing all replication origins created.
pg_replication_origin was added in PostgreSQL 9.5.
This table is shared across all databases in a cluster.
Definition by PostgreSQL version
pg_replication_origin (PostgreSQL 15)
Table "pg_catalog.pg_replication_origin"
Column | Type | Collation | Nullable | Default
---------+------+-----------+----------+---------
roident | oid | | not null |
roname | text | C | not null |
Indexes:
"pg_replication_origin_roiident_index" PRIMARY KEY, btree (roident), tablespace "pg_global"
"pg_replication_origin_roname_index" UNIQUE CONSTRAINT, btree (roname), tablespace "pg_global"
Tablespace: "pg_global"
Documentation: pg_replication_origin
pg_replication_origin (PostgreSQL 14)
Table "pg_catalog.pg_replication_origin"
Column | Type | Collation | Nullable | Default
---------+------+-----------+----------+---------
roident | oid | | not null |
roname | text | C | not null |
Indexes:
"pg_replication_origin_roiident_index" PRIMARY KEY, btree (roident), tablespace "pg_global"
"pg_replication_origin_roname_index" UNIQUE CONSTRAINT, btree (roname), tablespace "pg_global"
Tablespace: "pg_global"
Documentation: pg_replication_origin
pg_replication_origin (PostgreSQL 13)
Table "pg_catalog.pg_replication_origin"
Column | Type | Collation | Nullable | Default
---------+------+-----------+----------+---------
roident | oid | | not null |
roname | text | C | not null |
Indexes:
"pg_replication_origin_roiident_index" UNIQUE, btree (roident), tablespace "pg_global"
"pg_replication_origin_roname_index" UNIQUE, btree (roname), tablespace "pg_global"
Tablespace: "pg_global"
Documentation: pg_replication_origin
pg_replication_origin (PostgreSQL 12)
Table "pg_catalog.pg_replication_origin"
Column | Type | Collation | Nullable | Default
---------+------+-----------+----------+---------
roident | oid | | not null |
roname | text | C | not null |
Indexes:
"pg_replication_origin_roiident_index" UNIQUE, btree (roident), tablespace "pg_global"
"pg_replication_origin_roname_index" UNIQUE, btree (roname), tablespace "pg_global"
Tablespace: "pg_global"
Documentation: pg_replication_origin
pg_replication_origin (PostgreSQL 11)
Table "pg_catalog.pg_replication_origin"
Column | Type | Collation | Nullable | Default
---------+------+-----------+----------+---------
roident | oid | | not null |
roname | text | | not null |
Indexes:
"pg_replication_origin_roiident_index" UNIQUE, btree (roident), tablespace "pg_global"
"pg_replication_origin_roname_index" UNIQUE, btree (roname text_pattern_ops), tablespace "pg_global"
Tablespace: "pg_global"
Documentation: pg_replication_origin
pg_replication_origin (PostgreSQL 10)
Table "pg_catalog.pg_replication_origin"
Column | Type | Collation | Nullable | Default
---------+------+-----------+----------+---------
roident | oid | | not null |
roname | text | | not null |
Indexes:
"pg_replication_origin_roiident_index" UNIQUE, btree (roident), tablespace "pg_global"
"pg_replication_origin_roname_index" UNIQUE, btree (roname text_pattern_ops), tablespace "pg_global"
Tablespace: "pg_global"
Documentation: pg_replication_origin
pg_replication_origin (PostgreSQL 9.6)
Table "pg_catalog.pg_replication_origin"
Column | Type | Modifiers
---------+------+-----------
roident | oid | not null
roname | text | not null
Indexes:
"pg_replication_origin_roiident_index" UNIQUE, btree (roident), tablespace "pg_global"
"pg_replication_origin_roname_index" UNIQUE, btree (roname text_pattern_ops), tablespace "pg_global"
Tablespace: "pg_global"
Documentation: pg_replication_origin
pg_replication_origin (PostgreSQL 9.5)
Table "pg_catalog.pg_replication_origin"
Column | Type | Modifiers
---------+------+-----------
roident | oid | not null
roname | text | not null
Indexes:
"pg_replication_origin_roiident_index" UNIQUE, btree (roident), tablespace "pg_global"
"pg_replication_origin_roname_index" UNIQUE, btree (roname text_pattern_ops), tablespace "pg_global"
Tablespace: "pg_global"
Documentation: pg_replication_origin
Change history
This table has not been modified since it was added in PostgreSQL 9.5.
- PostgreSQL 9.5
- added (commit 5aa23504)
Examples
Example contents of pg_replication_origin:
postgres=# SELECT * FROM pg_replication_origin;
roident | roname
---------+---------------------------------------
1 | pgl_app_app_provider_app_subscription
(1 row)
References
- PostgreSQL documentation: pg_replication_origin