Hi
I tred this option but still i get the same message. Any more options that i
can try.
Regards
Rajaram J
----- Original Message -----
From: "Brad Nicholson" <bnichols@ca.afilias.info>
To: "Rajaram J" <rajarj@hotmail.com>
Cc: <pgsql-general@postgresql.org>
Sent: Thursday, August 16, 2007 9:35 PM
Subject: Re: [GENERAL] I get a error msg when i try to connect to the DB
> On Thu, 2007-08-16 at 21:16 +0530, Rajaram J wrote:
>> Hi
>>
>> I have installed PostGRESql 7.4.17 and when i try to connect to the db
>> i get the msg
>>
>> psql: FATAL: no pg_hba.conf entry for host "???", user "sfmdb",
>> database "LOGDB", SSL off
>>
> You are allowing local, non TCP/IP connctions, and connections through
> the loop back, but you are not allowing remote conncetions. You need an
> entry of some form that is
>
> host all all ??? 255.255.255.255 trust
>
> btw, trust is usually bad, you should use some form of authentication.
>
>> My pg_hba.conf entry is as below
>>
>>
>>
>> # TYPE DATABASE USER IP-ADDRESS IP-MASK
>> METHOD
>>
>> # Disable default configuration
>>
>> local all all
>> trust
>> # IPv4-style local connections:
>> host all all 127.0.0.1 255.255.255.255
>> trust
>> # IPv6-style local connections:
>> host all all ::1
>> ffff:ffff:ffff:ffff:ffff:ffff:ffff:ffff trust
>>
>>
>> can you please guide me on what the problem might be.
>>
>> Regards
>>
>> Rajaram
>>
>>
> --
> Brad Nicholson 416-673-4106
> Database Administrator, Afilias Canada Corp.
>
>