Received: from magus.postgresql.org (magus.postgresql.org [87.238.57.229]) by mail.postgresql.org (Postfix) with ESMTP id 61EE613C6999 for ; Fri, 4 May 2012 10:33:21 -0300 (ADT) Received: from mh8.mail.rice.edu ([128.42.201.24]) by magus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1SQIdJ-0005s3-6L for pgsql-admin@postgresql.org; Fri, 04 May 2012 13:33:20 +0000 Received: from mh8.mail.rice.edu (localhost.localdomain [127.0.0.1]) by mh8.mail.rice.edu (Postfix) with ESMTP id E0E07291D58; Fri, 4 May 2012 08:33:02 -0500 (CDT) Received: from mh8.mail.rice.edu (localhost.localdomain [127.0.0.1]) by mh8.mail.rice.edu (Postfix) with ESMTP id D623229762A; Fri, 4 May 2012 08:33:02 -0500 (CDT) X-Virus-Scanned: by amavis-2.6.4 at mh8.mail.rice.edu, auth channel Received: from mh8.mail.rice.edu ([127.0.0.1]) by mh8.mail.rice.edu (mh8.mail.rice.edu [127.0.0.1]) (amavis, port 10026) with ESMTP id hTygXTKiXcxb; Fri, 4 May 2012 08:33:02 -0500 (CDT) X-SMTP-Auth: no X-SMTP-Auth: no Received: from aart.rice.edu (aart.rice.edu [168.7.56.48]) by mh8.mail.rice.edu (Postfix) with ESMTP id 9D53D291D51; Fri, 4 May 2012 08:33:02 -0500 (CDT) Received: by aart.rice.edu (Postfix, from userid 18612) id 96919100589; Fri, 4 May 2012 08:33:02 -0500 (CDT) Date: Fri, 4 May 2012 08:33:02 -0500 From: "ktm@rice.edu" To: Thomas Kellerer Cc: pgsql-admin@postgresql.org Subject: Re: Getting "ident" to work in Windows Message-ID: <20120504133302.GG32303@aart.rice.edu> References: MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: User-Agent: Mutt/1.5.20 (2009-12-10) X-Pg-Spam-Score: -1.9 (-) X-Archive-Number: 201205/24 X-Sequence-Number: 39513 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. Regards, Ken