pg_subscription_rel

The pg_subscription_rel catalog provides information about per-relation subscription state.

Column name Data type Description
srsubid oid (references pg_subscription.oid) A reference to the subscription.
srrelid oid (references pg_class.oid) A reference to the relation.
srsubstate char The state code.
The possible values are:
  • i – Initialize.
  • d – Data copy in progress.
  • f – Finished table copy.
  • s – Synchronized.
  • r – Ready (normal replication).
srsublsn pg_lsn The remote LSN of the state change used for synchronization coordination when in the s or r states. Otherwise, NULL.