"Craig A. James" <cjames@xxxxxxxxxxxxxxxx> writes: > I had a 'scratch' database for testing, which I deleted, and then disk went out. No problem, no precious data. But now I can't drop the tablespace, or the user who had that as the default tablespace. > I thought about removing the tablespace from pg_tablespaces, but it seems wrong to be monkeying with the system tables. I still can't drop the user, and can't drop the tablespace. What's the right way to clear out Postgres when a disk fails and there's no reason to repair the disk? Probably best to make a dummy postgres-owned directory somewhere and repoint the symlink at it, then DROP TABLESPACE. CVS HEAD has recently been tweaked to be more forgiving of such cases... regards, tom lane
