X-Git-Url: https://git.openstreetmap.org./chef.git/blobdiff_plain/50600cca037b24dff8f811f546ff8a424bbb8423..c389f176ac7a568bedaa7bdd690438b72ecf35bf:/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..855e8dc6c 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,14 +61,9 @@ 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 -%> 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