On Thu, Apr 30, 2009 at 3:58 AM, Fujii Masao <masao.fu...@gmail.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 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers