From 99c72aee3351f4a5a1e9536eb009a9b282764a34 Mon Sep 17 00:00:00 2001 From: Jakub Czajka Date: Sun, 11 Feb 2024 13:42:43 +0100 Subject: [PATCH] [postgres] Read website logs from a database. --- postgres/pg_hba.conf | 35 ++++++++++++++++++----------------- 1 file changed, 18 insertions(+), 17 deletions(-) diff --git a/postgres/pg_hba.conf b/postgres/pg_hba.conf index 82e47e9..9feaea8 100755 --- a/postgres/pg_hba.conf +++ b/postgres/pg_hba.conf @@ -87,27 +87,28 @@ # maintenance (custom daily cronjobs, replication, and similar tasks). # # Database administrative login by Unix domain socket -local all postgres trust +local all postgres trust -# TYPE DATABASE USER ADDRESS METHOD +# TYPE DATABASE USER ADDRESS METHOD -local mail_db dovecot trust -host mail_db dovecot ::1/128 trust -host mail_db dkim ::1/128 trust -host analytics_db rsyslog ::1/128 trust -local gym_db gym_tracker trust -local matrix_db synapse_user trust -local metrics_db metrics_tracker trust -local payments_db payments_tracker trust +local mail_db dovecot trust +host mail_db dovecot ::1/128 trust +host mail_db dkim ::1/128 trust +host analytics_db rsyslog ::1/128 trust +local analytics_db analytics_reader trust +local gym_db gym_tracker trust +local matrix_db synapse_user trust +local metrics_db metrics_tracker trust +local payments_db payments_tracker trust # "local" is for Unix domain socket connections only -local all all peer +local all all peer # IPv4 local connections: -host all all 127.0.0.1/32 scram-sha-256 +host all all 127.0.0.1/32 scram-sha-256 # IPv6 local connections: -host all all ::1/128 scram-sha-256 +host all all ::1/128 scram-sha-256 # Allow replication connections from localhost, by a user with the # replication privilege. -local replication all peer -host replication all 127.0.0.1/32 scram-sha-256 -host replication all ::1/128 scram-sha-256 -hostssl all postgres 0.0.0.0/0 cert +local replication all peer +host replication all 127.0.0.1/32 scram-sha-256 +host replication all ::1/128 scram-sha-256 +hostssl all postgres 0.0.0.0/0 cert -- 2.39.5