pg_replication_origin
The pg_replication_origin catalog contains all replication origins created. For more on replication origins see Chapter 48. Unlike most system catalogs, pg_replication_origin is shared across all databases of a cluster: there is only one copy of pg_replication_origin per cluster, not one per database.
English manual coverage begins with PostgreSQL 7.4. Source history and runtime observations have their own recorded version boundaries.
Reading PG 18·Select a recorded version
- kind
- catalog
- lang
- en
- measured attributes
- true
- metadata release
- 18.6
- runtime columns
- roident, roname
- runtime verified
- false
- source
- english-manual
Definition PG 18
The pg_replication_origin catalog contains all replication origins created. For more on replication origins see Chapter 48. Unlike most system catalogs, pg_replication_origin is shared across all databases of a cluster: there is only one copy of pg_replication_origin per cluster, not one per database.
Catalog columns
| Column | Type | Nullability | Description |
|---|---|---|---|
| roident | oid | Not null | A unique, cluster-wide identifier for the replication origin. Should never leave the system. |
| roname | text | Not null | The external, user defined, name of a replication origin. |
Compare versions
Source references
Full definition and evidence JSON
Definition sources
center · PostgreSQL 18 · catalog-bilingual-repair:d27a801c51e0d707e6446ea6f6f27ec2fc058de7cb0d324d102ce68147ad4f74
Text language: en · catalog-bilingual-repair:d27a801c51e0d707e6446ea6f6f27ec2fc058de7cb0d324d102ce68147ad4f74