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

Postgres user authentification or LDAP authentification

From: "Lauris Ulmanis" <lauris(dot)ulmanis(at)mykoob(dot)com>
To: <pgsql-bugs(at)postgresql(dot)org>
Cc: <pgsql-performance(at)postgresql(dot)org>
Subject: Postgres user authentification or LDAP authentification
Date: 2009-07-23 10:47:47
Message-ID: 4a683fe4.22a0100a.5945.7413@mx.google.com (view raw or flat)
Thread:
Lists: pgsql-bugspgsql-performance
Hello!

 

I posted you a message about slowness of creation users more than 500 000
(#4919). It seems there is no workaround of this problem because of using
pg_auth flat file.

 

To override this problem is it possible to use LDAP authentification metod
to identify each user and speed up system? How it will affect group roles
for each user because we use groups roles to give Access to users to system
objects? Because group roles will work only with postgres users not LDAP.

 

pgBouncer or pgPool uses Postgres users for connection pooling. Is there
some more variants to use connection pooling without using postgres users?

 

 

______________________________________

Lauris Ulmanis

Tel. +371 29471020

 

 

 

Responses

pgsql-performance by date

Next:From: Robert HaasDate: 2009-07-23 23:22:41
Subject: Re: Performance difference between IN(...) and ANY(...) operator
Previous:From: David ReesDate: 2009-07-22 19:29:25
Subject: Re: Master/Slave, DB separation or just spend $$$?

pgsql-bugs by date

Next:From: Frank SpiesDate: 2009-07-23 12:56:36
Subject: BUG #4935: Weird input syntax for intervals, part 2
Previous:From: Tom LaneDate: 2009-07-23 00:34:47
Subject: Re: BUG #4934: regression in IN with joins in subselect

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