" FATAL: no pg_hba.conf entry for host" messages... - Mailing list pgsql-general

From Shafi DBA
Subject " FATAL: no pg_hba.conf entry for host" messages...
Date
Msg-id 20110519105406.BDFE5B5DBEA@mail.postgresql.org
Whole thread Raw
Responses Re: " FATAL: no pg_hba.conf entry for host" messages...  (Jasmin Dizdarevic <jasmin.dizdarevic@gmail.com>)
List pgsql-general

Folks,

 

Customer is getting below messages from one of their machines -  when connected to the database:

 


beaconinfra3      :    124.7.159.110 -- psql: FATAL:  no pg_hba.conf entry for host "202.144.77.14", user "root", database "beaconinfra3", SSL off
BW_Hosting      :    124.7.221.25  -- psql: FATAL:  no pg_hba.conf entry for host "10.1.6.6", user "root", database "BW_Hosting", SSL off
beaconidrbt1      :    124.7.159.50 -- psql: FATAL:  no pg_hba.conf entry for host "202.144.77.14", user "root", database "beaconidrbt1", SSL off
beaconware1     :    10.1.6.40 (172.16.32.9) -- psql: No pg_hba.conf entry for host 10.1.6.6, user root, database beaconware1

 

 

Looks like they are in the process of implementing an alert script as a result of which they are complaining of the above FATAL messages all of a sudden and is repetitive..

 

Can someone kindly advise?

 

As I am primarily an Oracle DBA – I would rather request a detailed issue cause and resolution to talk to the customer, before hand.

 

Thanks for your help in advance!

 

 

Best,

Shafi Ahmed

IS

Sify INDIA

 

"Science is more than a body of knowledge; it is a way of thinking"

 

pgsql-general by date:

Previous
From: Adarsh Sharma
Date:
Subject: Convert data into horizontal from vertical form
Next
From: Adarsh Sharma
Date:
Subject: Unexpected exit of Postgres terminal