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

Hi,

looks like a missing entry in pg_hba.conf for the requesting host.
Look here: http://www.postgresql.org/docs/8.2/static/auth-pg-hba-conf.html

<http://www.postgresql.org/docs/8.2/static/auth-pg-hba-conf.html>greets
jasmin

2011/5/19 Shafi DBA <shafi(dot)ahmed(at)sifycorp(dot)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"
>
>
>