From: | Dave Manginelli <dave(dot)manginelli(at)gmail(dot)com> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Subject: | SSPI Authentication on Windows 2012 (for Win. Clients) |
Date: | 2013-02-04 01:51:07 |
Message-ID: | CABsBUZX4r5dxCs4HUaYFczK9=dvGtYh--X3uHk8=X6q=meZbog@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
I'm running PostgreSQL 9.2 on Windows Server 2012 and I've attempted to
follow these instructions for single sign-on:
http://wiki.postgresql.org/wiki/Configuring_for_single_sign-on_using_SSPI_on_Windows
I followed the simplified instructions for 9.2 and successfully executed
the setspn command recommended there. However, I believe I still need to
follow the advice from the 9.1 section indicating that "you need to create
some login roles that have the same name as your domain users, and an entry
in pg_hba.conf with authentication method "sspi"."
I'm familiar with editing the pg_hba.conf file but I have no idea how to
add the required login roles on Windows Server 2012.
I'd very much appreciate it if someone could provide me with more detail or
point me to some additional documentation on how to add the required login
roles using Windows Server 2012's management tools.
Thanks
From | Date | Subject | |
---|---|---|---|
Next Message | Marko Rihtar | 2013-02-04 07:55:17 | Re: Avoid casting NULLs in UNION... |
Previous Message | Sergey Konoplev | 2013-02-02 07:56:05 | Re: Massive table bloat |