diff options
| author | Magnus Hagander <magnus@hagander.net> | 2017-01-14 17:14:56 +0100 |
|---|---|---|
| committer | Magnus Hagander <magnus@hagander.net> | 2017-01-14 17:14:56 +0100 |
| commit | f6d6d2920d2cddc4b381cbbf2915db9d985d20a9 (patch) | |
| tree | e4b2a4257a26062513d1239e705d1d45c62b1ff9 /src/backend/utils | |
| parent | 05cd12ed5bc74c853a161c5a138a0cb6f9b0cb8a (diff) | |
| download | postgresql-f6d6d2920d2cddc4b381cbbf2915db9d985d20a9.tar.gz postgresql-f6d6d2920d2cddc4b381cbbf2915db9d985d20a9.zip | |
Change default values for backup and replication parameters
This changes the default values of the following parameters:
wal_level = replica
max_wal_senders = 10
max_replication_slots = 10
in order to make it possible to make a backup and set up simple
replication on the default settings, without requiring a system restart.
Discussion: https://postgr.es/m/CABUevEy4PR_EAvZEzsbF5s+V0eEvw7shJ2t-AUwbHOjT+yRb3A@mail.gmail.com
Reviewed by Peter Eisentraut. Benchmark help from Tomas Vondra.
Diffstat (limited to 'src/backend/utils')
| -rw-r--r-- | src/backend/utils/misc/guc.c | 6 | ||||
| -rw-r--r-- | src/backend/utils/misc/postgresql.conf.sample | 6 |
2 files changed, 6 insertions, 6 deletions
diff --git a/src/backend/utils/misc/guc.c b/src/backend/utils/misc/guc.c index 5b23dbf4a0e..4e2bd4c496a 100644 --- a/src/backend/utils/misc/guc.c +++ b/src/backend/utils/misc/guc.c @@ -2315,7 +2315,7 @@ static struct config_int ConfigureNamesInt[] = NULL }, &max_wal_senders, - 0, 0, MAX_BACKENDS, + 10, 0, MAX_BACKENDS, NULL, NULL, NULL }, @@ -2326,7 +2326,7 @@ static struct config_int ConfigureNamesInt[] = NULL }, &max_replication_slots, - 0, 0, MAX_BACKENDS /* XXX? */ , + 10, 0, MAX_BACKENDS /* XXX? */ , NULL, NULL, NULL }, @@ -3749,7 +3749,7 @@ static struct config_enum ConfigureNamesEnum[] = NULL }, &wal_level, - WAL_LEVEL_MINIMAL, wal_level_options, + WAL_LEVEL_REPLICA, wal_level_options, NULL, NULL, NULL }, diff --git a/src/backend/utils/misc/postgresql.conf.sample b/src/backend/utils/misc/postgresql.conf.sample index b3f29610d07..15669b83c7f 100644 --- a/src/backend/utils/misc/postgresql.conf.sample +++ b/src/backend/utils/misc/postgresql.conf.sample @@ -174,7 +174,7 @@ # - Settings - -#wal_level = minimal # minimal, replica, or logical +#wal_level = replica # minimal, replica, or logical # (change requires restart) #fsync = on # flush data to disk for crash safety # (turning this off can cause @@ -229,12 +229,12 @@ # Set these on the master and on any standby that will send replication data. -#max_wal_senders = 0 # max number of walsender processes +#max_wal_senders = 10 # max number of walsender processes # (change requires restart) #wal_keep_segments = 0 # in logfile segments, 16MB each; 0 disables #wal_sender_timeout = 60s # in milliseconds; 0 disables -#max_replication_slots = 0 # max number of replication slots +#max_replication_slots = 10 # max number of replication slots # (change requires restart) #track_commit_timestamp = off # collect timestamp of transaction commit # (change requires restart) |