November 21, 2024: PostgreSQL 17.2, 16.6, 15.10, 14.15, 13.18, and 12.22 Released!
Supported Versions: Current (17) / 16 / 15 / 14 / 13
Development Versions: devel
Unsupported versions: 12 / 11 / 10 / 9.6 / 9.5
This documentation is for an unsupported version of PostgreSQL.
You may want to view the same page for the current version, or one of the other supported versions listed above instead.
52.43. pg_replication_origin
Prev  Up Chapter 52. System Catalogs Home  Next

52.43. pg_replication_origin

The pg_replication_origin catalog contains all replication origins created. For more on replication origins see Chapter 50.

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.

Table 52.43. pg_replication_origin Columns

Name Type References Description
roident Oid   A unique, cluster-wide identifier for the replication origin. Should never leave the system.
roname text   The external, user defined, name of a replication origin.

Prev  Up  Next
52.42. pg_range  Home  52.44. pg_rewrite