Movatterモバイル変換

[0]ホーム
URL:

Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

 Sign up
Appearance settings

Commit34fc616

Browse files
committed
Change hot_standby default value to 'on'
This goes together with the changes made to enable replication on thesending side by default (wal_level, max_wal_senders etc) by making thereceiving stadby node also enable it by default.Huong Dangminh
1 parenta99448a commit34fc616

File tree

4 files changed

+5
-5
lines changed

4 files changed

+5
-5
lines changed

‎doc/src/sgml/config.sgml‎

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -3227,7 +3227,7 @@ ANY <replaceable class="parameter">num_sync</replaceable> ( <replaceable class="
32273227
<para>
32283228
Specifies whether or not you can connect and run queries during
32293229
recovery, as described in <xref linkend="hot-standby">.
3230-
The default value is <literal>off</literal>.
3230+
The default value is <literal>on</literal>.
32313231
This parameter can only be set at server start. It only has effect
32323232
during archive recovery or in standby mode.
32333233
</para>

‎doc/src/sgml/high-availability.sgml‎

Lines changed: 2 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -2057,8 +2057,8 @@ if (!triggered)
20572057
<title>Administrator's Overview</title>
20582058

20592059
<para>
2060-
If <varname>hot_standby</> isturned<literal>on</> in
2061-
<filename>postgresql.conf</> and there is a <filename>recovery.conf</>
2060+
If <varname>hot_standby</> is <literal>on</> in <filename>postgresql.conf</>
2061+
(the default value) and there is a <filename>recovery.conf</>
20622062
file present, the server will run in Hot Standby mode.
20632063
However, it may take some time for Hot Standby connections to be allowed,
20642064
because the server will not accept connections until it has completed

‎src/backend/utils/misc/guc.c‎

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -1571,7 +1571,7 @@ static struct config_bool ConfigureNamesBool[] =
15711571
NULL
15721572
},
15731573
&EnableHotStandby,
1574-
false,
1574+
true,
15751575
NULL,NULL,NULL
15761576
},
15771577

‎src/backend/utils/misc/postgresql.conf.sample‎

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -254,7 +254,7 @@
254254

255255
# These settings are ignored on a master server.
256256

257-
#hot_standby =off# "on" allows queries during recovery
257+
#hot_standby =on# "off" disallows queries during recovery
258258
# (change requires restart)
259259
#max_standby_archive_delay = 30s# max delay before canceling queries
260260
# when reading WAL from archive;

0 commit comments

Comments
 (0)
[8]ページ先頭
©2009-2025 Movatter.jp