Re: Creating a tablespace directory in recovery

On Thu, Apr 30, 2009 at 3:58 AM, Fujii Masao <masao(dot)fujii(at)gmail(dot)com> wrote:
> Does anyone know why a tablespace directory isn't automatically
> created in recovery? I think that it's troublesome to create all the
> directories before recovery.

Well, there's some chance that if the directories don't exist, it's
because you haven't troubled to mount the correct partitions. And in
that case just blindly creating the directories will possibly lead to
a series of unfortunate events.

I generally think that it's not a good idea for PG to create
directories outside $PGDATA. I didn't much like the recent change
where (AIUI) we follow the symlink and create a directory in the right
place to be the target thereof. Those kinds of things strike me as
footguns waiting to go off. If something is not right, I would rather
have the system complain to me and stop than just do something that
might not be right. It's easier to fix my init scripts if PG is too
dumb than to work around PG trying to be too smart.

...Robert