Re: tablespaces and non-empty directories - Mailing list pgsql-hackers

From Tom Lane
Subject Re: tablespaces and non-empty directories
Date
Msg-id 25791.1132238048@sss.pgh.pa.us
Whole thread Raw
In response to Re: tablespaces and non-empty directories  ("Zeugswetter Andreas DCP SD" <ZeugswetterA@spardat.at>)
List pgsql-hackers
"Zeugswetter Andreas DCP SD" <ZeugswetterA@spardat.at> writes:
>> No.  There is no reason to use a volume's root directory as a
>> tablespace;
>> especially so since the root directory ought to be owned by root

> That is not so on AIX. Only the moint point (the dir in the parent) is
> root.
> Once mounted it can have (and preserves) any permission you want.

Yeah, you *can* make it not-root-owned on most Unixen.  That doesn't
mean it's a good idea to do so.  For instance, if the root directory
is owned by Joe Luser, what's to stop him from blowing away lost+found
and thereby screwing up future fscks?  You should basically never have
more-privileged objects (such as lost+found) inside directories owned by
less-privileged users --- it's just asking for trouble.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Jaime Casanova
Date:
Subject: Re: Optional postgres database not so optional in 8.1
Next
From: Tom Lane
Date:
Subject: Re: MERGE vs REPLACE