X-Git-Url: https://git.openstreetmap.org./chef.git/blobdiff_plain/8be8fedb8c020391df3e03290b063e418eb9e38a..45c0862be818c87ac9825ed36a7a2e9d3a1aab7c:/cookbooks/postgresql/templates/default/postgresql.conf.erb diff --git a/cookbooks/postgresql/templates/default/postgresql.conf.erb b/cookbooks/postgresql/templates/default/postgresql.conf.erb index 55053f5f8..a8bc83c05 100644 --- a/cookbooks/postgresql/templates/default/postgresql.conf.erb +++ b/cookbooks/postgresql/templates/default/postgresql.conf.erb @@ -20,11 +20,7 @@ listen_addresses = '<%= @settings[:listen_addresses] || @defaults[:listen_addres <% end -%> port = <%= @settings[:port] || @defaults[:port] %> max_connections = <%= @settings[:max_connections] || @defaults[:max_connections] %> -<% if @version.to_f >= 9.3 %> unix_socket_directories = '/var/run/postgresql' -<% else -%> -unix_socket_directory = '/var/run/postgresql' -<% end -%> # - Security and Authentication - @@ -47,12 +43,8 @@ max_stack_depth = <%= @settings[:max_stack_depth] || @defaults[:max_stack_depth] effective_io_concurrency = <%= @settings[:effective_io_concurrency] || @defaults[:effective_io_concurrency] %> max_worker_processes = <%= @settings[:max_worker_processes] || @defaults[:max_worker_processes] %> -<% if @version.to_f >= 9.6 -%> max_parallel_workers_per_gather = <%= @settings[:max_parallel_workers_per_gather] || @defaults[:max_parallel_workers_per_gather] %> -<% end -%> -<% if @version.to_f >= 10 -%> max_parallel_workers = <%= @settings[:max_parallel_workers] || @defaults[:max_parallel_workers] %> -<% end -%> #------------------------------------------------------------------------------ # WRITE AHEAD LOG @@ -69,15 +61,10 @@ commit_delay = <%= @settings[:commit_delay] || @defaults[:commit_delay] %> # - Checkpoints - -<% if @version.to_f < 9.5 -%> -checkpoint_segments = <%= @settings[:checkpoint_segments] || @defaults[:checkpoint_segments] %> -<% end -%> checkpoint_timeout = <%= @settings[:checkpoint_timeout] || @defaults[:checkpoint_timeout] %> -<% if @version.to_f >= 9.5 -%> +checkpoint_completion_target = <%= @settings[:checkpoint_completion_target] || @defaults[:checkpoint_completion_target] %> max_wal_size = <%= @settings[:max_wal_size] || @defaults[:max_wal_size] %> min_wal_size = <%= @settings[:min_wal_size] || @defaults[:min_wal_size] %> -<% end -%> -checkpoint_completion_target = <%= @settings[:checkpoint_completion_target] || @defaults[:checkpoint_completion_target] %> # - Archiving - @@ -101,9 +88,7 @@ restore_command = '<%= @settings[:restore_command] || @defaults[:restore_command # - Sending Server(s) - max_wal_senders = <%= @settings[:max_wal_senders] || @defaults[:max_wal_senders] %> -<% if @version.to_f >= 9.4 -%> max_replication_slots = <%= @settings[:max_replication_slots] || @defaults[:max_replication_slots] %> -<% end -%> # - Standby Servers - @@ -126,9 +111,7 @@ effective_cache_size = <%= @settings[:effective_cache_size] || @defaults[:effect # - Other Planner Options - default_statistics_target = <%= @settings[:default_statistics_target] || @defaults[:default_statistics_target] %> -<% if @version.to_f >= 12 -%> jit = <%= @settings[:jit] || @defaults[:jit] %> -<% end -%> #------------------------------------------------------------------------------ # REPORTING AND LOGGING @@ -140,6 +123,7 @@ log_min_duration_statement = <%= @settings[:log_min_duration_statement] || @defa # - What to Log - +log_autovacuum_min_duration = <%= @settings[:log_autovacuum_min_duration] || @defaults[:log_autovacuum_min_duration] %> log_line_prefix = '%t ' #------------------------------------------------------------------------------ @@ -157,7 +141,6 @@ stats_temp_directory = '/run/postgresql/<%= @version %>-main.pg_stat_tmp' # AUTOVACUUM PARAMETERS #------------------------------------------------------------------------------ -log_autovacuum_min_duration = <%= @settings[:log_autovacuum_min_duration] || @defaults[:log_autovacuum_min_duration] %> autovacuum_max_workers = <%= @settings[:autovacuum_max_workers] || @defaults[:autovacuum_max_workers] %> autovacuum_naptime = <%= @settings[:autovacuum_naptime] || @defaults[:autovacuum_naptime] %> autovacuum_vacuum_scale_factor = <%= @settings[:autovacuum_vacuum_scale_factor] || @defaults[:autovacuum_vacuum_scale_factor] %>