BUG #15508: Not able to connect irrespective of valid entries inpg_hba.conf
От | PG Bug reporting form |
---|---|
Тема | BUG #15508: Not able to connect irrespective of valid entries inpg_hba.conf |
Дата | |
Msg-id | 15508-4f247f02568dbf5f@postgresql.org обсуждение исходный текст |
Ответы |
Re: BUG #15508: Not able to connect irrespective of valid entries in pg_hba.conf
|
Список | pgsql-bugs |
The following bug has been logged on the website: Bug reference: 15508 Logged by: Yogesh Jadhav Email address: yogesh.jadhav@gmail.com PostgreSQL version: 11.1 Operating system: Windows 10 Description: I am trying to connect a Postgres database which resides in a docker installed on Ubuntu virtual machine. Following exception is being thrown on the console. org.postgresql.util.PSQLException: FATAL: no pg_hba.conf entry for host "10.1.X.X", user "usrXXX", database "dbXXX", SSL off After going through various posts, I realised that I have to update pg_hba.conf file. I have modified the file to include the following settings. host dbXXX usrXXX 10.1.X.X/32 trust *(Note I tried with md5 as well.)* I verified the postgres database settings through `psql` and executed commands as specified in this post(https://dba.stackexchange.com/questions/161104/pgadmin-postgresql-no-pg-hba-conf-entry-for-host). This verified that I am editing correct file. To take a step further, I also verified the entry through pgAdmin (*pgAdmin is installed locally on postgres host*) and found the following query is returning records as entered in pg_hba.conf table pg_hba_file_rules; You can get the images about infrastructure and pgAdmin query results at following URL. https://dba.stackexchange.com/questions/222602/not-able-to-connect-to-postgre-database-no-pg-hba-conf-entry-for-host
В списке pgsql-bugs по дате отправления: