pg_replication_origin — PostgreSQL system catalog

The PostgreSQL pg_replication_origin system catalog: full column reference (names, types, descriptions), catalog relationships and version support.

The Sev-1 Admin
The Sev-1 Admin  ·  1 min read

Summary

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

(Description quoted from the official PostgreSQL documentation.)

Columns

The pg_replication_origin system catalog exposes the following columns (names, types and descriptions are taken verbatim from the PostgreSQL documentation):

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

Version applicability

Present in PostgreSQL 17, 18, 19 (verified against each release’s documentation). This is a long-standing system object that also exists in earlier PostgreSQL releases.

Related & references

Reference: PostgreSQL documentation — pg_replication_origin.