Updated on 2024-06-03 GMT+08:00

PG_REPLICATION_ORIGIN

PG_REPLICATION_ORIGIN contains all created replication sources and is shared among all databases in a cluster. Each cluster has only one copy of PG_REPLICATION_ORIGIN, not one copy per database instance.

Table 1 PG_REPLICATION_ORIGIN columns

Name

Type

Description

roident

oid

Unique replication source identifier within a cluster.

roname

text

External user-defined replication source name.