diff options
Diffstat (limited to 'ansible/roles/postgres/files/postgresql.conf')
| -rw-r--r-- | ansible/roles/postgres/files/postgresql.conf | 53 |
1 files changed, 0 insertions, 53 deletions
diff --git a/ansible/roles/postgres/files/postgresql.conf b/ansible/roles/postgres/files/postgresql.conf deleted file mode 100644 index 9127fc7..0000000 --- a/ansible/roles/postgres/files/postgresql.conf +++ /dev/null @@ -1,53 +0,0 @@ -data_directory = '/var/lib/postgresql/15/main' -hba_file = '/etc/postgresql/15/main/pg_hba.conf' -ident_file = '/etc/postgresql/15/main/pg_ident.conf' -external_pid_file = '/var/run/postgresql/15-main.pid' -listen_addresses = '89.58.26.118,localhost' -port = 5432 -unix_socket_directories = '/var/run/postgresql' - -ssl = on -ssl_cert_file = '/etc/ssl/certs/ssl-cert-snakeoil.pem' -ssl_key_file = '/etc/ssl/private/ssl-cert-snakeoil.key' -ssl_ca_file = '/opt/pydis/ca.pem' - -dynamic_shared_memory_type = posix - -log_line_prefix = '%m [%p] %q%u@%d ' -log_timezone = 'Etc/UTC' -datestyle = 'iso, mdy' -timezone = 'Etc/UTC' -lc_messages = 'en_US.UTF-8' -lc_monetary = 'en_US.UTF-8' -lc_numeric = 'en_US.UTF-8' -lc_time = 'en_US.UTF-8' -default_text_search_config = 'pg_catalog.english' -include_dir = 'conf.d' - -cluster_name = 'schweinehund' - -# The following is from https://pgtune.leopard.in.ua/ -# DB Version: 15 -# OS Type: linux -# DB Type: mixed -# Total Memory (RAM): 64 GB -# CPUs num: 10 -# Connections num: 100 -# Data Storage: ssd -max_connections = 100 -shared_buffers = 16GB -effective_cache_size = 48GB -maintenance_work_mem = 2GB -checkpoint_completion_target = 0.9 -wal_buffers = 16MB -default_statistics_target = 100 -random_page_cost = 1.1 -effective_io_concurrency = 200 -work_mem = 20971kB -huge_pages = try -min_wal_size = 1GB -max_wal_size = 4GB -max_worker_processes = 10 -max_parallel_workers_per_gather = 4 -max_parallel_workers = 10 -max_parallel_maintenance_workers = 4 |