Re: I get a error msg when i try to connect to the DB

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.
>
>