Search code examples
postgresqlpgadmin

PostgreSQL pg_hba.conf Issue

In pg_hba.conf, I have

host    all             all             127.0.0.1/32            md5
host    all             all             samenet            md5

I also added 

host    all             all             samehost            md5

on both.

I am using pgAdminIII, trying create a "New Server Registration". When I connect to (localhost), it works fine. But when I change the host to the actual workstation name it says: 

FATAL: no pg_hba.conf entry for host "fe80::c81c:9e9c:6570:d0bf%20", user "postgres", database "postgres", SSL off

Additional Information

  • Operating system: Windows 7 Ultimate 32 bit
  • PostgreSQL Server 9.0.2

Any help on this would be highly appreciated.

Solution

  • This is the issue of PostgreSQL installations on Windows computers having IPv6 enabled. Temporary workaround would be passing paramter "-h 127.0.01" as described in this article.

    http://postgresql.1045698.n5.nabble.com/FATAL-no-pg-hba-conf-entry-for-host-1-td1873063.html