From 159db2fd0619f93d330bbe9815ece76beca34aba Mon Sep 17 00:00:00 2001 From: =?utf8?q?Isma=C3=ABl=20Bouya?= Date: Sun, 18 Feb 2018 11:52:05 +0100 Subject: [PATCH] Add localhost access for postgres --- modules/profile/manifests/postgresql.pp | 20 +++++++++++++++++++- 1 file changed, 19 insertions(+), 1 deletion(-) diff --git a/modules/profile/manifests/postgresql.pp b/modules/profile/manifests/postgresql.pp index 50e510e..8dcc4cb 100644 --- a/modules/profile/manifests/postgresql.pp +++ b/modules/profile/manifests/postgresql.pp @@ -33,6 +33,24 @@ class profile::postgresql { auth_method => 'ident', order => "a1", } + postgresql::server::pg_hba_rule { 'localhost access as postgres user': + description => 'Allow localhost access to postgres user', + type => 'host', + database => 'all', + user => $pg_user, + address => "127.0.0.1/32", + auth_method => 'md5', + order => "a2", + } + postgresql::server::pg_hba_rule { 'localhost ip6 access as postgres user': + description => 'Allow localhost access to postgres user', + type => 'host', + database => 'all', + user => $pg_user, + address => "::1/128", + auth_method => 'md5', + order => "a3", + } postgresql::server::pg_hba_rule { 'deny access to postgresql user': description => 'Deny remote access to postgres user', type => 'host', @@ -40,7 +58,7 @@ class profile::postgresql { user => $pg_user, address => "0.0.0.0/0", auth_method => 'reject', - order => "a2", + order => "a4", } postgresql::server::pg_hba_rule { 'local access': -- 2.41.0