The following bug has been logged online:
Bug reference: 6110
Logged by: Binod Nepal
Email address: nepalbinod@yahoo.com
PostgreSQL version: 9.0.2
Operating system: Windows 7 Ultimate 32/64
Description: pg_hba.conf samehost does not work
Details:
pg_hba.conf
# IPv4 local connections:
host all all 127.0.0.1/32 md5
host all all samehost md5
host all all samenet md5
# IPv6 local connections:
host all all ::1/128 md5
host all all samehost md5
host all all samenet md5
postgresql.conf
listen_addresses = '*'
SYSTEM DETAILS
Operating System
Windows 7 Ultimate 32 or 64 bit
Computer Name
SERVER
PostgreSQL Server Version
PostgreSQL 9.0.2
BUG DESCRIPTION
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
even when I have
host all all samehost md5
on pg_hba.conf on IPv4 and IPv6 settings.
PLEASE NOTE
I am trying to connect to the server from the same machine.
ADDITIONAL INFORMATION
If I connect to "SERVER" from other computers on the same network, it
works.
For further information, please contact.