On 02/22/11 10:38 PM, itishree sukla wrote:
Hi All,
I am using System DSN, that connects to postgreSQL, to fetch data
from the database, and put into xls sheet .Its working fine with most
of the machines and connects fine but on 1 machine i am getting this
FATAL: no pg_hba.conf entry for host “::1******”, user “postgres”,
database “myDatabase", SSL off error. Any idea why it is so, please
suggest.
Thanks in advance ...
::1 is the IPv6 localhost. sounds like this system has ipv6 configured,
so you probably want a line in pg_hba.conf like...
hosts all all ::1 md5
(replace the md5 with whatever you normally use on the localhost linet
hat looks like
hosts all all 127.0.0.0/8 md5
the other common value is 'trust'. md5 requires a password, trust doesn't.
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
