pg_replication_origin
A system catalogue 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 (commit 5aa23504).
This table is shared across all databases in a cluster.
Definition by PostgreSQL version
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 remained unchanged since its introduction in PostgreSQL 9.5.
References
- PostgreSQL documentation: pg_replication_origin