Re: Password sub-process ...

Bruce Momjian <pgman@candle.pha.pa.us>

From: Bruce Momjian <pgman@candle.pha.pa.us>
To: "Marc G. Fournier" <scrappy@hub.org>
Cc: pgsql-hackers@postgresql.org
Date: 2002-07-30T03:03:11Z
Lists: pgsql-hackers
Marc G. Fournier wrote:
> 
> Something to maybe add to the TODO list, if someone has the
> time/inclination to work on it ...
> 
> The problem with the current auth system, as I see it, is that you can't
> easily have seperate user lists and passwords per database ... its shared
> across the system ...
> 
> The closest you can get is to have a database defined as 'password' in
> pg_hba.conf, with an external password file from pg_shadow, which, for the
> most part, is good ... but it doesn't lend itself well to a 'hands off'
> server ...

Actually, that is removed in 7.3.  It was too weird a syntax and format
and the original idea of sharing /etc/passwd there didn't work anymore
on most systems.

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026