Re: HTTP user authentication against PostgreSQL - Mailing list pgsql-general

From Jeremy Palmer
Subject Re: HTTP user authentication against PostgreSQL
Date
Msg-id C6B695652D5E6B4597E90C5734C024262551A0F9B1@prdlsmmsg01.ad.linz.govt.nz
Whole thread Raw
In response to Re: HTTP user authentication against PostgreSQL  (John R Pierce <pierce@hogranch.com>)
List pgsql-general
Ok thanks for the advice John - much appreciated.
________________________________________
From: pgsql-general-owner@postgresql.org [pgsql-general-owner@postgresql.org] On Behalf Of John R Pierce
[pierce@hogranch.com]
Sent: Friday, 30 January 2015 10:33 p.m.
To: pgsql-general@postgresql.org
Subject: Re: [GENERAL] HTTP user authentication against PostgreSQL

On 1/30/2015 12:31 AM, Jeremy Palmer wrote:
> The PostgreSQL DB is currently setup with Kerberos for Windows SSO, as well as MD5 password authentication for
anotherpool of other PostgreSQL users who are not part of our Active Directory. LDAP could be used, but then we would
haveto move the current external users into the AD, and I'm not sure that can happen due to policy reasons. 

active directory IS a sort of ldap.    I'd be looking at connecting
apache to that AD too, and not trying to do it via postgres. associating
a postgres connection with each HTTP client session would be inefficent
and ugly, especially as http can have multiple threads for a single
client session, yet http is considered sessionless.



--
john r pierce                                      37N 122W
somewhere on the middle of the left coast



--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

This message contains information, which may be in confidence and may be subject to legal privilege. If you are not the
intendedrecipient, you must not peruse, use, disseminate, distribute or copy this message. If you have received this
messagein error, please notify us immediately (Phone 0800 665 463 or info@linz.govt.nz) and destroy the original
message.LINZ accepts no responsibility for changes to this email, or for any attachments, after its transmission from
LINZ.Thank You. 


pgsql-general by date:

Previous
From: Israel Brewster
Date:
Subject: Re: Server statistics monitoring?
Next
From: John R Pierce
Date:
Subject: Re: Server statistics monitoring?