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  (Greg Clough <greg.clough@ipreo.com>)
Список 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 по дате отправления:

Предыдущее
От: Michael Paquier
Дата:
Сообщение: Re: BUG #15159: Duplicate records for same primary key
Следующее
От: Greg Clough
Дата:
Сообщение: RE: BUG #15162: individual user can connect from anywhere withpgadmin