Can't drop tablespace or user after disk gone

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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?

Thanks,
Craig


[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux