summaryrefslogtreecommitdiff
path: root/public/fs/home/pgsql/data
diff options
context:
space:
mode:
authorroot@culturestrings <root@culturestrings>2020-05-21 06:20:15 +0000
committerroot@culturestrings <root@culturestrings>2020-05-21 07:56:17 +0000
commitdc05ebcd0a58364eee143693e3c9c9f4fe93de96 (patch)
tree17c176207e062b647d645d8a2ada33a734056de1 /public/fs/home/pgsql/data
parent6e174e40654a967b752691b6adb158d3abe9ae7e (diff)
downloadculturestrings-dc05ebcd0a58364eee143693e3c9c9f4fe93de96.tar.bz2
culturestrings-dc05ebcd0a58364eee143693e3c9c9f4fe93de96.tar.xz
postgresql: current configuration (enabled scram-sha-256 and openvpn access).
Diffstat (limited to 'public/fs/home/pgsql/data')
-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"