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"
looks like a missing entry in pg_hba.conf for the requesting host.
jasmin
2011/5/19 Shafi DBA <shafi.ahmed@xxxxxxxxxxxx>
