From dc05ebcd0a58364eee143693e3c9c9f4fe93de96 Mon Sep 17 00:00:00 2001 From: "root@culturestrings" Date: Thu, 21 May 2020 06:20:15 +0000 Subject: postgresql: current configuration (enabled scram-sha-256 and openvpn access). --- public/fs/home/pgsql/data/pg_hba.conf | 16 ++++++++++++++++ 1 file changed, 16 insertions(+) create mode 100644 public/fs/home/pgsql/data/pg_hba.conf (limited to 'public/fs/home/pgsql/data/pg_hba.conf') 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 -- cgit v1.2.3