Re: postgresql-7.1.3 pg_ctl password authentication and startup - Mailing list pgsql-patches

From Tom Lane
Subject Re: postgresql-7.1.3 pg_ctl password authentication and startup
Date
Msg-id 24569.1002867914@sss.pgh.pa.us
Whole thread Raw
In response to Re: postgresql-7.1.3 pg_ctl password authentication and startup  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-patches
Bruce Momjian <pgman@candle.pha.pa.us> writes:
> Can I get comments on this?

Ugh.

> It allows storage of a super-user password
> in a file under /data that gets passed in psql.  I don't like the fact
> the password is stored unencrypted

Entirely unacceptable IMHO.  We just spent a large amount of work to
eliminate the need to keep any unencrypted passwords inside $PGDATA
... and this patch proposes to sling one right back in there, in an
easy-to-find place no less.  Mess up the protection on $PGDATA, and
you've given away the store.

pg_ctl is certainly in need of work for systems that use password
security, but this is not a good fix.

            regards, tom lane

pgsql-patches by date:

Previous
From: Bradley McLean
Date:
Subject: Re: psql: default base and password reading
Next
From: Thomas Lockhart
Date:
Subject: Re: psql: default base and password reading