Thread: " FATAL: no pg_hba.conf entry for host" messages...

" FATAL: no pg_hba.conf entry for host" messages...

From
"Shafi DBA"
Date:

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"

 

Re: " FATAL: no pg_hba.conf entry for host" messages...

From
Jasmin Dizdarevic
Date:
Hi, 

looks like a missing entry in pg_hba.conf for the requesting host.

greets
jasmin

2011/5/19 Shafi DBA <shafi.ahmed@sifycorp.com>

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"