↑↓ select ↵ open ⌫ change scope Open full search

PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.

Supported versions: Current (18) / 17 / 16 / 15 / 14
Development versions: 19 / devel
Unsupported versions: 13 / 12 / 11 / 10
Historical version. PostgreSQL 13 reached end of support in November 2025. See the current version for supported releases.
51.53. pg_subscription_rel
Prev  Up Chapter 51. System Catalogs Home  Next

51.53. pg_subscription_rel

The catalog pg_subscription_rel contains the state for each replicated relation in each subscription. This is a many-to-many mapping.

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

Table 51.53. pg_subscription_rel Columns

Column Type

Description

srsubid oid (references pg_subscription.oid)

Reference to subscription

srrelid oid (references pg_class.oid)

Reference to relation

srsubstate char

State code: i = initialize, d = data is being copied, s = synchronized, r = ready (normal replication)

srsublsn pg_lsn

Remote LSN of the state change used for synchronization coordination when in s or r states, otherwise null

Prev  Up  Next
51.52. pg_subscription  Home  51.54. pg_tablespace

Report a documentation issue

Read the upstream documentation. For corrections, first check the current version.