Mark Kirkwood <markir(at)paradise(dot)net(dot)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