Allow read-only queries on a standby during recovery.
At a glance
| Property | Value |
|---|---|
| Parameter | hot_standby |
| Category | Replication |
| Default | on |
| Value type | boolean / enum / numeric |
| Change scope | Restart required |
What it does
When on, a standby in recovery accepts read-only connections and queries.
How to apply a change
Requires a full server restart (postmaster context). Set it in postgresql.conf and restart PostgreSQL.
Inspect the current value and source with SHOW hot_standby; or SELECT name, setting, unit, context, source FROM pg_settings WHERE name = 'hot_standby';.
Tuning guidance
Keep on to use standbys for read scaling. Pair with conflict tuning (max_standby_streaming_delay, hot_standby_feedback).