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.

Categories

Cluster-wide table, Replication, System catalogue

See also

pg_replication_origin_status