Re: Can Postgres 8.x start if some disks containing tablespaces are not mounted?

Morris Goldstein napsal(a):

> But that makes me wonder: what about this sequence of events:
>
> - Postgres running normally on /dev/sda and /dev/sdb.
> - Update to table in /dev/sdb tablespace is committed but still exists in WAL.
> - Postgres crashes (e.g. power failure).
> - Postgres starts with /dev/sda only.
> - Recovery needs to update table in /dev/sdb tablespace.
>
> I assume bad things will happen in this case.

yes, Probably best solution in this case is to implemented tablespace
availability into postgreSQL and PostgreSQL shouldn't start when tablespace is
missing.

        Zdenek