Re: I get a error msg when i try to connect to the DB - Mailing list pgsql-general

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.