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" <[EMAIL PROTECTED]>
To: "Rajaram J" <[EMAIL PROTECTED]>
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.
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings
