summaryrefslogtreecommitdiff
path: root/public/fs/home/pgsql
diff options
context:
space:
mode:
Diffstat (limited to 'public/fs/home/pgsql')
-rw-r--r--public/fs/home/pgsql/data/pg_hba.conf16
-rw-r--r--public/fs/home/pgsql/data/postgresql.conf42
-rw-r--r--public/fs/home/pgsql/data/postmaster.opts1
3 files changed, 59 insertions, 0 deletions
diff --git a/public/fs/home/pgsql/data/pg_hba.conf b/public/fs/home/pgsql/data/pg_hba.conf
new file mode 100644
index 0000000..6abd582
--- /dev/null
+++ b/public/fs/home/pgsql/data/pg_hba.conf
@@ -0,0 +1,16 @@
+# PostgreSQL Client Authentication Configuration File
+# ===================================================
+
+# local DATABASE USER METHOD [OPTIONS]
+# host DATABASE USER ADDRESS METHOD [OPTIONS]
+# hostssl DATABASE USER ADDRESS METHOD [OPTIONS]
+# hostnossl DATABASE USER ADDRESS METHOD [OPTIONS]
+
+local all all peer
+host all all 127.0.0.1/32 scram-sha-256
+host all all 10.8.0.0/24 scram-sha-256
+host all all ::1/128 scram-sha-256
+
+local replication all peer
+host replication all 127.0.0.1/32 scram-sha-256
+host replication all ::1/128 scram-sha-256
diff --git a/public/fs/home/pgsql/data/postgresql.conf b/public/fs/home/pgsql/data/postgresql.conf
new file mode 100644
index 0000000..45d0eab
--- /dev/null
+++ b/public/fs/home/pgsql/data/postgresql.conf
@@ -0,0 +1,42 @@
+listen_addresses = 'localhost, 10.8.0.1'
+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'
diff --git a/public/fs/home/pgsql/data/postmaster.opts b/public/fs/home/pgsql/data/postmaster.opts
new file mode 100644
index 0000000..12dcaf0
--- /dev/null
+++ b/public/fs/home/pgsql/data/postmaster.opts
@@ -0,0 +1 @@
+/usr/lib/postgresql10/bin/postgres "-D" "/home/pgsql/data"