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