Contents

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 16)

    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 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.

Examples

Example contents of pg_replication_origin:

postgres=# SELECT * FROM pg_replication_origin;
 roident |                  roname
---------+---------------------------------------
       1 | pgl_app_app_provider_app_subscription
(1 row)

Categories

Cluster-wide table, Replication, System catalogue

See also

pg_replication_origin_status, pg_replication_origin_create(), pg_replication_origin_drop()