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.ah...@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" > > >
