From: | PG Bug reporting form <noreply(at)postgresql(dot)org> |
---|---|
To: | pgsql-bugs(at)lists(dot)postgresql(dot)org |
Cc: | ravikkumar(dot)22(at)gmail(dot)com |
Subject: | BUG #15162: individual user can connect from anywhere with pgadmin |
Date: | 2018-04-19 09:34:56 |
Message-ID: | 152413049686.459.7999942934911476625@wrigleys.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
The following bug has been logged on the website:
Bug reference: 15162
Logged by: Ravikumar S
Email address: ravikkumar(dot)22(at)gmail(dot)com
PostgreSQL version: 10.3
Operating system: rhel
Description:
in pg_hba.conf
host all all 0.0.0.0/0 only pgadmin work from anywhere.
host all user 0.0.0.0/0 user cant connect from anywhere
my project's application server running from XX.XXX.XX.XX and i created
user for accessing database from that host
so in pg_hba.conf i configured this for app user.
host db1 apuser xx.xx.xxx.xxx/0
for monitoring purpose i created one more user with select permission only
he should connect database from anywhere.
with below configuration
host db1 apuser xx.xxx.xx.xx ---------for app user only connect
from that ip address
host db1 monuser 0.0.0.0/0 --------- this user should connect
from anywhere
its not working...is there any way for individual user connection
restriction in pg_hba.conf file.???
please help with this
From | Date | Subject | |
---|---|---|---|
Next Message | Greg Clough | 2018-04-19 10:11:18 | RE: BUG #15162: individual user can connect from anywhere with pgadmin |
Previous Message | Michael Paquier | 2018-04-19 05:27:32 | Re: BUG #15159: Duplicate records for same primary key |