diff options
| author | root@culturestrings <root@culturestrings> | 2020-05-21 06:20:15 +0000 |
|---|---|---|
| committer | root@culturestrings <root@culturestrings> | 2020-05-21 07:56:17 +0000 |
| commit | dc05ebcd0a58364eee143693e3c9c9f4fe93de96 (patch) | |
| tree | 17c176207e062b647d645d8a2ada33a734056de1 /public | |
| parent | 6e174e40654a967b752691b6adb158d3abe9ae7e (diff) | |
| download | culturestrings-dc05ebcd0a58364eee143693e3c9c9f4fe93de96.tar.bz2 culturestrings-dc05ebcd0a58364eee143693e3c9c9f4fe93de96.tar.xz | |
postgresql: current configuration (enabled scram-sha-256 and openvpn access).
Diffstat (limited to 'public')
| -rw-r--r-- | public/fs/home/pgsql/data/pg_hba.conf | 16 | ||||
| -rw-r--r-- | public/fs/home/pgsql/data/postgresql.conf | 42 | ||||
| -rw-r--r-- | public/fs/home/pgsql/data/postmaster.opts | 1 |
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" |