pg_stat_replication.sync_state
Synchronous state of this standby server. Possible values are: async: This standby server is asynchronous. potential: This standby server is now asynchronous, but can potentially become synchronous if one of current synchronous ones fails. sync: This standby server is synchronous. quorum: This standby server is considered as a candidate for quorum standbys.
Reading PG 18·Select a recorded version
- View
- pg_stat_replication
- Field
- sync_state
- SQL type
- text
- Units named in the field definition
- Not specified
- Reset observation
- No stats_reset field is documented for this view
- documented
- true
- field
- sync_state
- manual path
- /docs/18/monitoring-stats.html
- signature
- SELECT sync_state FROM pg_catalog.pg_stat_replication;
- source only
- false
- sql type
- text
- units mentioned
- Unknown
- view
- pg_stat_replication
Definition PG 18
Synchronous state of this standby server. Possible values are: async: This standby server is asynchronous. potential: This standby server is now asynchronous, but can potentially become synchronous if one of current synchronous ones fails. sync: This standby server is synchronous. quorum: This standby server is considered as a candidate for quorum standbys.
Compare versions
Source references
Full definition and evidence JSON
Definition sources
center · PostgreSQL 18 · 555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f
Text language: en · 555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f