Re: Auto create (top level) directory for create tablespace

Mark Kirkwood <markir@paradise.net.nz> writes:
> I thought it made sense for CREATE TABLESPACE to attempt to create the
> top level location directory -

I thought we had deliberately made it not do that.  Auto-recreate during
replay sounds even worse.  The problem is that a tablespace would
normally be under a mount point, and auto-create has zero chance of
getting such a path right.

Ignoring this point is actually a fine recipe for destroying your data;
see Joe Conway's report a couple years back about getting burnt by a
soft NFS mount.  If the DB directory is not there, auto-creating it is
a horrible idea.

            regards, tom lane