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/test | |
| 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/test')
| -rw-r--r-- | src/test/modules/commit_ts/t/002_standby.pl | 1 | ||||
| -rw-r--r-- | src/test/modules/commit_ts/t/003_standby_2.pl | 1 | ||||
| -rw-r--r-- | src/test/perl/PostgresNode.pm | 6 | ||||
| -rw-r--r-- | src/test/recovery/t/006_logical_decoding.pl | 1 | ||||
| -rw-r--r-- | src/test/recovery/t/008_fsm_truncation.pl | 1 |
5 files changed, 5 insertions, 5 deletions
diff --git a/src/test/modules/commit_ts/t/002_standby.pl b/src/test/modules/commit_ts/t/002_standby.pl index 4dbde2978e4..ff600445406 100644 --- a/src/test/modules/commit_ts/t/002_standby.pl +++ b/src/test/modules/commit_ts/t/002_standby.pl @@ -15,7 +15,6 @@ $master->append_conf( 'postgresql.conf', qq{ track_commit_timestamp = on max_wal_senders = 5 - wal_level = hot_standby }); $master->start; $master->backup($bkplabel); diff --git a/src/test/modules/commit_ts/t/003_standby_2.pl b/src/test/modules/commit_ts/t/003_standby_2.pl index 043ccb14a5d..1775b22dadf 100644 --- a/src/test/modules/commit_ts/t/003_standby_2.pl +++ b/src/test/modules/commit_ts/t/003_standby_2.pl @@ -14,7 +14,6 @@ $master->append_conf( 'postgresql.conf', qq{ track_commit_timestamp = on max_wal_senders = 5 - wal_level = hot_standby }); $master->start; $master->backup($bkplabel); diff --git a/src/test/perl/PostgresNode.pm b/src/test/perl/PostgresNode.pm index d8be1bd3e12..932478183a8 100644 --- a/src/test/perl/PostgresNode.pm +++ b/src/test/perl/PostgresNode.pm @@ -415,7 +415,6 @@ sub init if ($params{allows_streaming}) { - print $conf "wal_level = replica\n"; print $conf "max_wal_senders = 5\n"; print $conf "wal_keep_segments = 20\n"; print $conf "max_wal_size = 128MB\n"; @@ -424,6 +423,11 @@ sub init print $conf "hot_standby = on\n"; print $conf "max_connections = 10\n"; } + else + { + print $conf "wal_level = minimal\n"; + print $conf "max_wal_senders = 0\n"; + } if ($TestLib::windows_os) { diff --git a/src/test/recovery/t/006_logical_decoding.pl b/src/test/recovery/t/006_logical_decoding.pl index b80a9a9415a..1716360a170 100644 --- a/src/test/recovery/t/006_logical_decoding.pl +++ b/src/test/recovery/t/006_logical_decoding.pl @@ -10,7 +10,6 @@ my $node_master = get_new_node('master'); $node_master->init(allows_streaming => 1); $node_master->append_conf( 'postgresql.conf', qq( -max_replication_slots = 4 wal_level = logical )); $node_master->start; diff --git a/src/test/recovery/t/008_fsm_truncation.pl b/src/test/recovery/t/008_fsm_truncation.pl index 9f6bdb0b64b..5220611e445 100644 --- a/src/test/recovery/t/008_fsm_truncation.pl +++ b/src/test/recovery/t/008_fsm_truncation.pl @@ -14,7 +14,6 @@ $node_master->init(allows_streaming => 1); $node_master->append_conf('postgresql.conf', qq{ fsync = on -wal_level = replica wal_log_hints = on max_prepared_transactions = 5 autovacuum = off |