Re: [BUG] SSPI authentication fails on Windows when server parameter is localhost or domain name

On Wed, Jun 15, 2011 at 10:53 AM, Ahmed Shinwari
<ahmed(dot)shinwari(at)gmail(dot)com> wrote:
> Hi All,
>
> I faced a bug on Windows while connecting via SSPI authentication. I was
> able to find the bug and have attached the patch. Details listed below;
>
> Postgres Installer: Version 9.0.4
> OS: Windows Server 2008 R2/Windows 7
>
> Bug Description:
> =============
> If database Server is running on Windows ('Server 2008 R2' or 'Windows 7')
> with authentication mode SSPI and one try to connect from the same machine
> via 'psql' with server parameter as 'localhost' or 'fully qualified domain
> name', the database throws error;

I've been able to reproduce this issue, and the patch does indeed fix
it. One of our customers has also confirmed it fixed it for them.

--
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company