Re: check for missing tablespaces?

Andrew Dunstan <andrew@dunslane.net> writes:
> I am in the middle of helping a customer recover from a situation where 
> a tablespace was missing when a machine was rebooted and postgres 
> restarted, and I'm wondering if we should not have some sort of check 
> for this on startup. Maybe we could check for the existence of the 
> PG_VERSION file or something like that?

... and do what?

What exactly went wrong so badly with the missing tablespace?  Doesn't
seem like it should be any worse than if individual table files went
missing.
        regards, tom lane