From 0a04b63d7a60cade183df8248a13eb83ef6cefa2 Mon Sep 17 00:00:00 2001 From: Philip Guyton Date: Fri, 10 Nov 2023 12:47:46 +0000 Subject: [PATCH] Ease database diagnosis via local IP access configuration #2730 Add to Postgresql's Host Based Authentication config (pg_hba.conf), remarked out examples of enabling IPv4 & IPv6 based access, from localhost. Typical DB interfaces found in IDEs are limited to IP access only, and so cannot connect using the unix socket only configuration used by Rockstor. --- conf/pg_hba.conf | 6 ++++++ 1 file changed, 6 insertions(+) diff --git a/conf/pg_hba.conf b/conf/pg_hba.conf index 8dfe797b3..ec514d6a6 100644 --- a/conf/pg_hba.conf +++ b/conf/pg_hba.conf @@ -96,3 +96,9 @@ local test_smartdb rocky md5 # local replication all peer # host replication all 127.0.0.1/32 ident # host replication all ::1/128 ident + +# "host" IPv4 & IPv6 connections - e.g. IDE localhost only DB diagnostics +# host storageadmin rocky 127.0.0.1/32 md5 +# host smartdb rocky 127.0.0.1/32 md5 +# host storageadmin rocky ::1/128 md5 +# host smartdb rocky ::1/128 md5 \ No newline at end of file