Re: tablespaces and non-empty directories

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: tablespaces and non-empty directories
Дата
Msg-id 25791.1132238048@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: tablespaces and non-empty directories  ("Zeugswetter Andreas DCP SD" <ZeugswetterA@spardat.at>)
Список 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 по дате отправления:

Предыдущее
От: Jaime Casanova
Дата:
Сообщение: Re: Optional postgres database not so optional in 8.1
Следующее
От: Tom Lane
Дата:
Сообщение: Re: MERGE vs REPLACE