BUG #15162: individual user can connect from anywhere with pgadmin
От | PG Bug reporting form |
---|---|
Тема | BUG #15162: individual user can connect from anywhere with pgadmin |
Дата | |
Msg-id | 152413049686.459.7999942934911476625@wrigleys.postgresql.org обсуждение исходный текст |
Ответы |
RE: BUG #15162: individual user can connect from anywhere withpgadmin
|
Список | pgsql-bugs |
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
В списке pgsql-bugs по дате отправления: