From 01c50af77ff170738714a3ada132477382ac8479 Mon Sep 17 00:00:00 2001 From: Cullum Smith Date: Tue, 17 Jun 2025 17:20:31 -0400 Subject: pgsql update --- .../postgres/data16/pg_hba.conf.postgresql_server | 5 --- .../data16/pg_ident.conf.postgresql_server | 3 -- .../data16/postgresql.conf.postgresql_server | 43 ---------------------- .../postgres/data17/pg_hba.conf.postgresql_server | 5 +++ .../data17/pg_ident.conf.postgresql_server | 3 ++ .../data17/postgresql.conf.postgresql_server | 43 ++++++++++++++++++++++ 6 files changed, 51 insertions(+), 51 deletions(-) delete mode 100644 files/var/db/postgres/data16/pg_hba.conf.postgresql_server delete mode 100644 files/var/db/postgres/data16/pg_ident.conf.postgresql_server delete mode 100644 files/var/db/postgres/data16/postgresql.conf.postgresql_server create mode 100644 files/var/db/postgres/data17/pg_hba.conf.postgresql_server create mode 100644 files/var/db/postgres/data17/pg_ident.conf.postgresql_server create mode 100644 files/var/db/postgres/data17/postgresql.conf.postgresql_server (limited to 'files/var') diff --git a/files/var/db/postgres/data16/pg_hba.conf.postgresql_server b/files/var/db/postgres/data16/pg_hba.conf.postgresql_server deleted file mode 100644 index 4810eb9..0000000 --- a/files/var/db/postgres/data16/pg_hba.conf.postgresql_server +++ /dev/null @@ -1,5 +0,0 @@ -# TYPE DATABASE USER ADDRESS METHOD -local all postgres peer map=postgres -local all all peer -hostgssenc all all all gss include_realm=0 krb_realm=${realm} -hostssl all all all ldap ldapserver="${ldap_hosts}" ldaptls=1 ldapbinddn="${postgres_dn}" ldapbindpasswd="${postgres_ldap_password}" ldapbasedn="${users_basedn}" ldapsearchattribute=uid diff --git a/files/var/db/postgres/data16/pg_ident.conf.postgresql_server b/files/var/db/postgres/data16/pg_ident.conf.postgresql_server deleted file mode 100644 index 1076453..0000000 --- a/files/var/db/postgres/data16/pg_ident.conf.postgresql_server +++ /dev/null @@ -1,3 +0,0 @@ -# MAPNAME SYSTEM-USERNAME PG-USERNAME -postgres postgres postgres -postgres root postgres diff --git a/files/var/db/postgres/data16/postgresql.conf.postgresql_server b/files/var/db/postgres/data16/postgresql.conf.postgresql_server deleted file mode 100644 index 55874e7..0000000 --- a/files/var/db/postgres/data16/postgresql.conf.postgresql_server +++ /dev/null @@ -1,43 +0,0 @@ -listen_addresses = '*' -max_connections = ${postgres_max_connections} - -krb_server_keyfile = 'FILE:${postgres_keytab}' -krb_caseins_users = on - -ssl = on -ssl_ca_file = '${site_cacert_path}' -ssl_cert_file = '${postgres_tls_cert}' -ssl_key_file = '${postgres_tls_key}' -ssl_min_protocol_version = 'TLSv1.3' - -shared_buffers = '${postgres_shared_buffers}B' -temp_buffers = '${postgres_temp_buffers}B' -work_mem = '${postgres_work_mem}B' -maintenance_work_mem = '${postgres_maintenance_work_mem}B' -dynamic_shared_memory_type = posix - -wal_sync_method = fdatasync -full_page_writes = off -wal_compression = off -wal_init_zero = off -wal_recycle = off -max_wal_size = 1GB -min_wal_size = 80MB - -effective_cache_size = '${postgres_effective_cache_size}B' - -log_destination = 'syslog' -syslog_sequence_numbers = off - -log_min_messages = info -log_min_error_statement = warning -log_line_prefix = '[%p] %q%u@%d ' -log_timezone = 'US/Eastern' - -datestyle = 'iso, mdy' -timezone = 'US/Eastern' -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/files/var/db/postgres/data17/pg_hba.conf.postgresql_server b/files/var/db/postgres/data17/pg_hba.conf.postgresql_server new file mode 100644 index 0000000..4810eb9 --- /dev/null +++ b/files/var/db/postgres/data17/pg_hba.conf.postgresql_server @@ -0,0 +1,5 @@ +# TYPE DATABASE USER ADDRESS METHOD +local all postgres peer map=postgres +local all all peer +hostgssenc all all all gss include_realm=0 krb_realm=${realm} +hostssl all all all ldap ldapserver="${ldap_hosts}" ldaptls=1 ldapbinddn="${postgres_dn}" ldapbindpasswd="${postgres_ldap_password}" ldapbasedn="${users_basedn}" ldapsearchattribute=uid diff --git a/files/var/db/postgres/data17/pg_ident.conf.postgresql_server b/files/var/db/postgres/data17/pg_ident.conf.postgresql_server new file mode 100644 index 0000000..1076453 --- /dev/null +++ b/files/var/db/postgres/data17/pg_ident.conf.postgresql_server @@ -0,0 +1,3 @@ +# MAPNAME SYSTEM-USERNAME PG-USERNAME +postgres postgres postgres +postgres root postgres diff --git a/files/var/db/postgres/data17/postgresql.conf.postgresql_server b/files/var/db/postgres/data17/postgresql.conf.postgresql_server new file mode 100644 index 0000000..55874e7 --- /dev/null +++ b/files/var/db/postgres/data17/postgresql.conf.postgresql_server @@ -0,0 +1,43 @@ +listen_addresses = '*' +max_connections = ${postgres_max_connections} + +krb_server_keyfile = 'FILE:${postgres_keytab}' +krb_caseins_users = on + +ssl = on +ssl_ca_file = '${site_cacert_path}' +ssl_cert_file = '${postgres_tls_cert}' +ssl_key_file = '${postgres_tls_key}' +ssl_min_protocol_version = 'TLSv1.3' + +shared_buffers = '${postgres_shared_buffers}B' +temp_buffers = '${postgres_temp_buffers}B' +work_mem = '${postgres_work_mem}B' +maintenance_work_mem = '${postgres_maintenance_work_mem}B' +dynamic_shared_memory_type = posix + +wal_sync_method = fdatasync +full_page_writes = off +wal_compression = off +wal_init_zero = off +wal_recycle = off +max_wal_size = 1GB +min_wal_size = 80MB + +effective_cache_size = '${postgres_effective_cache_size}B' + +log_destination = 'syslog' +syslog_sequence_numbers = off + +log_min_messages = info +log_min_error_statement = warning +log_line_prefix = '[%p] %q%u@%d ' +log_timezone = 'US/Eastern' + +datestyle = 'iso, mdy' +timezone = 'US/Eastern' +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