BUG #15162: individual user can connect from anywhere with pgadmin
The following bug has been logged on the website:
Bug reference: 15162
Logged by: Ravikumar S
Email address: ravikkumar.22@gmail.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
Hi Ravikumar,
This isn't a bug, so please post it to a more appropriate list such as pgsql-admin:
https://www.postgresql.org/list/
But first, try debugging it yourself:
https://www.postgresql.org/docs/10/static/auth-pg-hba-conf.html
The format of your config lines doesn't seem correct, so check your postgresql.log for errors when you reload it.
Greg Clough
Senior Technology Engineer
Ipreo
Castle House | 37-35 Paul St | London EC2A 4LS
-----Original Message-----
From: PG Bug reporting form [mailto:noreply@postgresql.org]
Sent: Thursday, April 19, 2018 10:35 AM
To: pgsql-bugs@lists.postgresql.org
Cc: ravikkumar.22@gmail.com
Subject: BUG #15162: individual user can connect from anywhere with pgadmin
The following bug has been logged on the website:
Bug reference: 15162
Logged by: Ravikumar S
Email address: ravikkumar.22@gmail.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
Confidential Disclaimer: ****************************************************************** This e-mail message and any attachments are confidential. Dissemination, distribution or copying of this e-mail or any attachments by anyone other than the intended recipient is prohibited. If you are not the intended recipient, please notify Ipreo immediately by replying to this e-mail, and destroy all copies of this e-mail and any attachments. Thank you! ******************************************************************