From: Tom Hughes Date: Fri, 27 Jan 2023 08:39:41 +0000 (+0000) Subject: Default wal_level to replica X-Git-Url: https://git.openstreetmap.org./chef.git/commitdiff_plain/c9f9e7c106d1bdc14ef5a5b97712d25ec0ad9e6a Default wal_level to replica --- diff --git a/cookbooks/postgresql/attributes/default.rb b/cookbooks/postgresql/attributes/default.rb index fd1afcea1..54a224345 100644 --- a/cookbooks/postgresql/attributes/default.rb +++ b/cookbooks/postgresql/attributes/default.rb @@ -13,7 +13,7 @@ default[:postgresql][:settings][:defaults][:effective_io_concurrency] = "1" default[:postgresql][:settings][:defaults][:max_worker_processes] = "8" default[:postgresql][:settings][:defaults][:max_parallel_workers_per_gather] = "2" default[:postgresql][:settings][:defaults][:max_parallel_workers] = "8" -default[:postgresql][:settings][:defaults][:wal_level] = "minimal" +default[:postgresql][:settings][:defaults][:wal_level] = "replica" default[:postgresql][:settings][:defaults][:fsync] = "on" default[:postgresql][:settings][:defaults][:synchronous_commit] = "on" default[:postgresql][:settings][:defaults][:wal_buffers] = "-1"