Re: Limit on number of users in postgresql?

From: Bill Moran <wmoran(at)collaborativefusion(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: "Willy-Bas Loos" <willybas(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: Limit on number of users in postgresql?
Date: 2007-01-29 17:53:47
Message-ID: 20070129125347.cf82b7d1.wmoran@collaborativefusion.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

In response to Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>:

> Bill Moran <wmoran(at)collaborativefusion(dot)com> writes:
> > In response to Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>:
> >> Yeah, but the postmaster can't read pg_authid, nor any other table,
> >> because it's not logically connected to the database. So any change
> >> to pg_authid gets copied to a "flat" ASCII-text file for the postmaster.
>
> > Would using kerberos or some other external auth mechanism work around this?
>
> Kerberos can't read the database directly either, so I'm not sure I see
> your point.

It's possible that I'm misunderstanding.

If there's a problem with having large numbers of users in Postgres because
the postmaster has to use a flat file to store them, can one circumvent the
issue by configuring Postgres to use kerberos for auth instead of its
internal mechanisms? Will this eliminate the need for the flat file?

--
Bill Moran
Collaborative Fusion Inc.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Alvaro Herrera 2007-01-29 18:03:52 Re: Limit on number of users in postgresql?
Previous Message Michael Artz 2007-01-29 17:52:33 Re: encode, lower and 0x8a