From 2caf08d5dd9d82087c16390a34e8ab169be75369 Mon Sep 17 00:00:00 2001 From: "root@culturestrings" Date: Wed, 1 Jul 2020 08:57:05 +0000 Subject: networking: introduced $vpn_net4, $vpn_ipv5, $host_ipv4, $host_ipv6. --- public/fs/home/pgsql/data/postgresql.conf.in | 42 ++++++++++++++++++++++++++++ 1 file changed, 42 insertions(+) create mode 100644 public/fs/home/pgsql/data/postgresql.conf.in (limited to 'public/fs/home/pgsql/data/postgresql.conf.in') diff --git a/public/fs/home/pgsql/data/postgresql.conf.in b/public/fs/home/pgsql/data/postgresql.conf.in new file mode 100644 index 0000000..42a1c26 --- /dev/null +++ b/public/fs/home/pgsql/data/postgresql.conf.in @@ -0,0 +1,42 @@ +listen_addresses = 'localhost, @vpn_ipv4@' +port = 5432 +max_connections = 128 +superuser_reserved_connections = 16 + +password_encryption = scram-sha-256 +db_user_namespace = off +row_security = on + +shared_buffers = 256MB +huge_pages = on +temp_buffers = 8MB +max_prepared_transactions = 0 + +work_mem = 16MB +maintenance_work_mem = 512MB +replacement_sort_tuples = 150000 +autovacuum_work_mem = -1 +max_stack_depth = 4MB +dynamic_shared_memory_type = posix + +log_destination = 'stderr' +logging_collector = on + +log_directory = 'log' +log_filename = 'postgresql-%Y-%m-%d_%H%M%S.log' +log_file_mode = 0600 +log_truncate_on_rotation = off +log_rotation_age = 1d +log_rotation_size = 10MB +log_line_prefix = '%m %d %u [%p]' + +datestyle = 'iso, mdy' +intervalstyle = 'postgres' +timezone_abbreviations = 'Default' + +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' -- cgit v1.2.3