Re: Ignore lost+found when checking if a directory is empty

Поиск
Список
Период
Сортировка
Искать
От
Bruce Momjian
Тема
Re: Ignore lost+found when checking if a directory is empty
Дата
Msg-id
201108140223.p7E2NaJ24955@momjian.us
Ответ на
Список
Дерево обсуждения
Ignore lost+found when checking if a directory is empty Brian Pitts <bdp@uga.edu>
Re: Ignore lost+found when checking if a directory is empty Tom Lane <tgl@sss.pgh.pa.us>
Re: Ignore lost+found when checking if a directory is empty Jeff Davis <pgsql@j-davis.com>
Re: Ignore lost+found when checking if a directory is empty Alvaro Herrera <alvherre@commandprompt.com>
Re: Ignore lost+found when checking if a directory is empty Tom Lane <tgl@sss.pgh.pa.us>
Re: Ignore lost+found when checking if a directory is empty Bruce Momjian <bruce@momjian.us>
Re: Ignore lost+found when checking if a directory is empty Jeff Davis <pgsql@j-davis.com>
Re: Ignore lost+found when checking if a directory is empty Jaime Casanova <jaime@2ndquadrant.com>
Tom Lane wrote:
> Alvaro Herrera  writes:
> > Excerpts from Jeff Davis's message of mar ago 09 16:03:26 -0400 2011:
> >> I think I agree with Peter here that it's not a very good idea, and I
> >> don't see a big upside. With tablespaces it seems to make a little bit
> >> more sense, but I'd still lean away from that idea.
> 
> > What if the init script tries to start postmaster before the filesystems
> > are mounted?  ISTM requiring a subdir is a good sanity check that the
> > system is ready to run.  Not creating stuff directly on the mountpoint
> > ensures consistency.
> 
> I went looking in the archives for previous discussions of this idea.
> Most of them seem to focus on tablespaces rather than the primary data
> directory, but the objections to doing it are pretty much the same

FYI, the 9.0+ code will create a subdirectory under the tablespace
directory named after the catversion number, and it doesn't check that
the directory is empty, particularly so pg_upgrade can do its magic.
So, I believe lost+found would work in such a case, but again, the
security issues are real.

--  Bruce Momjian          http://momjian.us EnterpriseDB                             http://enterprisedb.com
 + It's impossible for everything to be true. +

В списке pgsql-hackers по дате отправления
От: Heikki Linnakangas
Дата:
Сообщение: Re: VACUUM FULL versus TOAST
От: Robert Haas
Дата:
FAQ