Postgres Pro
Downloads
Home   >   mailing lists

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

From Jasmin Dizdarevic
Subject Re: " FATAL: no pg_hba.conf entry for host" messages...
Date
Msg-id BANLkTinUePmqxJB6mi+M6Ba6t-B+-R9byA@mail.gmail.com
Whole thread Raw
In response to " FATAL: no pg_hba.conf entry for host" messages...  ("Shafi DBA" <shafi.ahmed@sifycorp.com>)
List pgsql-general
Tree view
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"

 


pgsql-general by date:

Previous
From: Raghavendra
Date:
Subject: Re: Unexpected exit of Postgres terminal
Next
From: Leif Jensen
Date:
Subject: ECPG selecting into char arrays