On Tue, 23 May 2000, Lincoln Yeoh wrote:
> At 11:35 AM 18-05-2000 -0400, Andrew Sullivan wrote:
> >On Thu, May 18, 2000 at 11:05:58AM -0400, Tom Lane wrote:
> >> "Len Morgan" <len-morgan@crcom.net> writes:
> >> > RedHat based rpm installations create the postgres superuser account as
> >> > part of the process and set the home directory for this user to PG_DATA.
> >> To be blunt, that's *incredibly* brain dead.
> >Does Red Hat actually make the _data_ directory the home? Debian avoids
> >this by making /var/lib/postgres the home, and data/ under that the PGDATA
> >directory. It sure doesn't seem a good idea to be using PGDATA as a home
> >directory.
> I dunno, AFAIK it didn't seem to do such a thing. If it did, it should be
> changed- very dangerous. Files may be uploaded or written to unfortunate
> places.
PostgreSQL 7.0 RPMs place home for postgres to be /var/lib/pgsql, and PGDATA is
/var/lib/pgsql/data. I just _look_ stupid. :-) The postgres user's home was
changed for 7.0 just exactly because of the bad choice of home being PGDATA.
--
Lamar Owen
WGCR Internet Radio
1 Peter 4:11