pg_replication_origin_status

A system catalogue view showing the approximate state of replay for a certain origin

pg_replication_origin_status is a system catalogue view showing the approximate state of replay for a certain origin. It is based on the underlying system catalogue table pg_replication_origin.

pg_replication_origin_status was added in PostgreSQL 9.5 (commit 5aa23504).

Definition by PostgreSQL version

pg_replication_origin_status (PostgreSQL 13)

    View "pg_catalog.pg_replication_origin_status"
   Column    |  Type  | Collation | Nullable | Default
-------------+--------+-----------+----------+---------
 local_id    | oid    |           |          |
 external_id | text   |           |          |
 remote_lsn  | pg_lsn |           |          |
 local_lsn   | pg_lsn |           |          |
    

Documentation: pg_replication_origin_status

pg_replication_origin_status (PostgreSQL 12)

    View "pg_catalog.pg_replication_origin_status"
   Column    |  Type  | Collation | Nullable | Default
-------------+--------+-----------+----------+---------
 local_id    | oid    |           |          |
 external_id | text   |           |          |
 remote_lsn  | pg_lsn |           |          |
 local_lsn   | pg_lsn |           |          |
    

Documentation: pg_replication_origin_status

pg_replication_origin_status (PostgreSQL 11)

    View "pg_catalog.pg_replication_origin_status"
   Column    |  Type  | Collation | Nullable | Default
-------------+--------+-----------+----------+---------
 local_id    | oid    |           |          |
 external_id | text   |           |          |
 remote_lsn  | pg_lsn |           |          |
 local_lsn   | pg_lsn |           |          |
    

Documentation: pg_replication_origin_status

pg_replication_origin_status (PostgreSQL 10)

    View "pg_catalog.pg_replication_origin_status"
   Column    |  Type  | Collation | Nullable | Default
-------------+--------+-----------+----------+---------
 local_id    | oid    |           |          |
 external_id | text   |           |          |
 remote_lsn  | pg_lsn |           |          |
 local_lsn   | pg_lsn |           |          |
    

Documentation: pg_replication_origin_status

pg_replication_origin_status (PostgreSQL 9.6)

View "pg_catalog.pg_replication_origin_status"
   Column    |  Type  | Modifiers
-------------+--------+-----------
 local_id    | oid    |
 external_id | text   |
 remote_lsn  | pg_lsn |
 local_lsn   | pg_lsn |
    

Documentation: pg_replication_origin_status

pg_replication_origin_status (PostgreSQL 9.5)

View "pg_catalog.pg_replication_origin_status"
   Column    |  Type  | Modifiers
-------------+--------+-----------
 local_id    | oid    |
 external_id | text   |
 remote_lsn  | pg_lsn |
 local_lsn   | pg_lsn |
    

Documentation: pg_replication_origin_status

Change history

This view has remained unchanged since its introduction in PostgreSQL 9.5.

Categories

Logical replication, Replication, System catalogue

See also

pg_replication_origin