Re: initdb and "exit_nicely"...

From: Lincoln Yeoh <lylyeoh(at)mecomb(dot)com>
To: Andrew Sullivan <sullivana(at)bpl(dot)on(dot)ca>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Len Morgan <len-morgan(at)crcom(dot)net>, pgsql-general(at)hub(dot)org
Subject: Re: initdb and "exit_nicely"...
Date: 2000-05-24 01:39:40
Message-ID: 3.0.5.32.20000524093940.008d1d50@pop.mecomb.po.my
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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(at)crcom(dot)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.

I think initdb should NOT touch existing PGDATA directories. Let the user
take the responsibility for rm -rf or moving/renaming. If PGDATA exists it
should leave it, or at worst rename it to PGDATA.old.1 (increasing number
or maybe datetime).

This way less badness is likely to happen. Sure it's a bit inconvenient to
have to delete stuff yourself, but compared to accidentally deleting a
whole bunch of stuff, I think mv or rm are easy (in fact I bet some people
have found them too easy ;) ).

Cheerio,

Link.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Lincoln Yeoh 2000-05-24 02:07:08 Re: PostgreSQL cleartext passwords
Previous Message Tatsuo Ishii 2000-05-24 01:19:59 Re: quick (and probably dumb) question