To: pgsql-admin@postgresql.org
From: Thomas Kellerer <spam_eater@gmx.net>
Subject: Getting "ident" to work in Windows
Date: Fri, 04 May 2012 13:57:47 +0200
Lines: 36
Message-ID: <jo0g4q$pq8$1@dough.gmane.org>
Mime-Version: 1.0
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US;
	rv:1.8.1.23) Gecko/20090812 Thunderbird/2.0.0.23 Mnenhy/0.7.6.666

Hi,

I'm trying to enable "ident" authentication on my Windows machine using PostgreSQL 9.1

However as soon as I add the following line to pg_hba.conf

    host    all             all             ::1/128            ident sameuser

I get an error message when trying to login (after a server reload of course)

    psql: FATAL:  could not load pg_hba.conf

It is precisely that line above. As soon as I remove it I can logon again (with a username/password of course).

I did verify that my connections are done through IPV6.

Here is the current content of my pg_hba.conf:

--------- snip ----------
# TYPE  DATABASE        USER            ADDRESS                 METHOD

# IPv4 local connections:
host    all             all             127.0.0.1/32            md5

# IPv6 local connections:
host    all             all             ::1/128              md5
--------- snip ----------

Ideally I would like to make "ident" to work with a custom map but using "ident tkmap". But that throws the same error which isn't really surprising as "ident tkmap" is not working either.

Is ident not supported on Windows? I could not find anything related to that in the manual.

Regards
Thomas