> Bruce Momjian <pgman@candle.pha.pa.us> writes:
> > Why do we bother supporting passwords in pg_shadow and secondary files?
>
> So the same user can have different passwords for different databases.
>
> It's a pretty crude hack, since there isn't any support for updating
> the secondary password files except via manual editing done by the
> dbadmin. But I wouldn't be in favor of taking it out until we can
> replace that functionality elsewhere.
We have pg_passwd which does allow updating of the files.
-- Bruce Momjian | http://www.op.net/~candle 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,
Pennsylvania19026