Skip site navigation (1) Skip section navigation (2)

Re: Getting "ident" to work in Windows

From: Magnus Hagander <magnus(at)hagander(dot)net>
To: "ktm(at)rice(dot)edu" <ktm(at)rice(dot)edu>
Cc: Thomas Kellerer <spam_eater(at)gmx(dot)net>, pgsql-admin(at)postgresql(dot)org
Subject: Re: Getting "ident" to work in Windows
Date: 2012-05-04 13:35:31
Message-ID: CABUevEy-GYxqQsMO+uxr6B+3FDHLrWT-OnqT0ZTttf+B+=kYug@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-admin
On Fri, May 4, 2012 at 3:33 PM, ktm(at)rice(dot)edu <ktm(at)rice(dot)edu> wrote:
> On Fri, May 04, 2012 at 01:57:47PM +0200, Thomas Kellerer wrote:
>> 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
>>
>
> I believe that that is the case. There is no Windows ident support.

There should be ident support for Windows. Just not over local
connections ("peer") - since local connections are not supported.

-- 
 Magnus Hagander
 Me: http://www.hagander.net/
 Work: http://www.redpill-linpro.com/

In response to

pgsql-admin by date

Next:From: ktm@rice.eduDate: 2012-05-04 13:38:42
Subject: Re: Very long "<IDLE> in transaction" query
Previous:From: ktm@rice.eduDate: 2012-05-04 13:33:02
Subject: Re: Getting "ident" to work in Windows

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group