↑↓ select↵ open⌫ change scopeOpen full search

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

Wiki / Configuration Parameters

hot_standby

Specifies whether or not you can connect and run queries during recovery, as described in Section 26.4. The default value is on. This parameter can only be set at server start. It only has effect during archive recovery or in standby mode.

English manual coverage begins with PostgreSQL 7.4. Source history and runtime observations have their own recorded version boundaries.

Reading PG 18·Select a recorded version

boot val
on
category
Replication / Standby Servers
context
postmaster
doc same as
Unknown
documented
true
enumvals
Unknown
extra desc
Unknown
lang
en
max val
Unknown
metadata version
18
min val
Unknown
name
hot_standby
short desc
Allows connections and queries during recovery.
source
pg-settings-source-snapshot
unit
Unknown
vartype
bool

Definition PG 18

Specifies whether or not you can connect and run queries during recovery, as described in Section 26.4. The default value is on. This parameter can only be set at server start. It only has effect during archive recovery or in standby mode.

Compare versions

Complete source facts

doc html

<p>
        Specifies whether or not you can connect and run queries during
        recovery, as described in <a class="xref" href="/docs/18/hot-standby.html" title="26.4. Hot Standby">Section 26.4</a>.
        The default value is <code class="literal">on</code>.
        This parameter can only be set at server start. It only has effect
        during archive recovery or in standby mode.
       </p>

documentation revision

{"inputs":[{"file":"runtime-config-replication.html","kind":"same-version-reviewed-manual","locale":"en","sha256":"c0b8bd86131ec62d4df97ce480d004aa7e3544477d053f0c2d4047b9edad5cc0","version":"18.7"},{"file":"runtime-config-replication.html","kind":"same-version-reviewed-manual","locale":"zh-Hans","sha256":"83907b5f469e979a7b9ec875b5e7bdaa2ef6b85596ca31b45174f68cd7398b18","version":"18.7"}],"release":"18.7","runtime_remeasured":false,"source_revision":"pgdoc:b9f0e7232f60f380d642ac9b99226606c254b552"}

Source references

Full definition and evidence JSON

Definition sources

center · PostgreSQL 18 · wiki-repair-20261023:c4338610739acd13d4f14c4e29f22f1a950273ccec594401b5cd96ceb92f1e6f

Text language: en · wiki-repair-20261023:c4338610739acd13d4f14c4e29f22f1a950273ccec594401b5cd96ceb92f1e6f