1 files changed, 42 insertions, 0 deletions
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'