PG_SUBSCRIPTION_REL

The system catalog PG_SUBSCRIPTION_REL contains the status of each replicated table in each subscription. It is a many-to-many mapping.

This system catalog contains only tables known to the subscription after running CREATE SUBSCRIPTION or ALTER SUBSCRIPTION… REFRESH PUBLICATION.

Table 1 PG_SUBSCRIPTION_REL columns

Name

Type

Description

srsubid

oid

Identifier of the subscription.

srrelid

oid

Subscription relationship ID.

srsubstate

char

Subscription status.

  • i: Initialization.
  • d: Basic data being replicated.
  • f: Basic data replication completed.
  • s: Progress synchronized with incremental replication.
  • r: Incremental replication ready.

  • srcsn

    int8

    Snapshot CSN during basic data replication.

    srsublsn

    text

    Remote LSN used to synchronize the incremental replication progress in the s or r state. Otherwise, the value is null.

    Feedback
    编组 3备份
      openGauss 2024-07-20 01:00:34
      cancel