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

Re: How to setup PostgreSQL using Windows Authentication?

From: Peter Cheung <Pcheung(at)sfcu(dot)org>
To: 'Craig Ringer' <ringerc(at)ringerc(dot)id(dot)au>
Cc: "'pgsql-admin(at)postgresql(dot)org'" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: How to setup PostgreSQL using Windows Authentication?
Date: 2012-06-12 18:37:27
Message-ID: 583566AE01BD5948A12C964BD739A9A24686BFFC@HARRY.sfcu.intr (view raw, whole thread or download thread mbox)
Lists: pgsql-admin
According to, SSPI only works when GSSAPI is available and GSSAPI support has to be enabled when PostgreSQL is built.   Does it mean that I need to uninstall PostgreSQL and reinstall it with GSSAPI support?  I used the One click installer downloaded from to install PostgreSQL and I'm not sure how to include GSSAPI support.

From: Craig Ringer [mailto:ringerc(at)ringerc(dot)id(dot)au]
Sent: Tuesday, June 12, 2012 1:11 AM
To: Peter Cheung
Cc: 'pgsql-admin(at)postgresql(dot)org'
Subject: Re: [ADMIN] How to setup PostgreSQL using Windows Authentication?

On 06/12/2012 10:00 AM, Peter Cheung wrote:


I'm new to PostgreSQL.   I installed PostgreSQL on a Windows Server 2008 R2 server.   I have created a database and an user in Windows Active Directory.  How can I configure that user to access that database?
By default, Windows users and PostgreSQL users are completely separate.

Use PgAdmin-III to create the user, or a "CREATE USER" command in psql. See

It is also possible to use SSPI authentication with PostgreSQL, so PostgreSQL authenticates users against Active Directory. I haven't used it myself. The user must still be created in PostgreSQL, SSPI just takes care of authenticating them using their Windows credentials. See:

Craig Ringer

In response to


pgsql-admin by date

Next:From: Lonni J FriedmanDate: 2012-06-12 18:37:42
Subject: Re: pg_basebackup blocking all queries with horrible performance
Previous:From: Amador AlvarezDate: 2012-06-12 17:59:44
Subject: Hot backup for postgres 8.4

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