Thread: FATAL: no pg_hba.conf entry for host “::1***"

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.

On 23/02/2011 08:19, itishree sukla wrote:
> Hi John,
> Thanks  for your reply, however the the address is starting with  host
> "58.137.154.189". It was working fine before, however not working in
> new system.
>

Well, that's an IPv4 address, and as John said it looks as if your new
system is trying to connect over IPv6.

Ray.

--
Raymond O'Donnell :: Galway :: Ireland
rod@iol.ie