Re: BUG #6110: pg_hba.conf samehost does not work

On Mon, Jul 11, 2011 at 5:13 AM, Binod Nepal <nepalbinod(at)yahoo(dot)com> wrote:
> # 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

I don't think it accomplishes anything at all to have the same lines
in there twice. The comment doesn't affect whether the line applies
to IPv4 or IPv6.

ISTM the problem here must be the Windows version of
pg_foreach_ifaddr(), which uses this method to try to get a list of
addresses:

WSAIoctl(sock, SIO_GET_INTERFACE_LIST, 0, 0,
ii, n_ii * sizeof(INTERFACE_INFO),
&length, 0, 0)

Perhaps there's a better method we could be using, but I have no idea
what it is. A quick Google search didn't turn up any IPv6-related
restrictions on SIO_GET_INTERFACE_LIST.

--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company