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