Can't drop tablespace or user after disk gone

Поиск
Список
Период
Сортировка
От Craig A. James
Тема Can't drop tablespace or user after disk gone
Дата
Msg-id 4613D5BC.2070607@modgraph-usa.com
обсуждение исходный текст
Ответ на Re: SCSI vs SATA  (Stefan Kaltenbrunner <stefan@kaltenbrunner.cc>)
Ответы Re: Can't drop tablespace or user after disk gone
Список pgsql-performance
I had a 'scratch' database for testing, which I deleted, and then disk went out.  No problem, no precious data.  But
nowI 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
failsand there's no reason to repair the disk? 

Thanks,
Craig

В списке pgsql-performance по дате отправления:

Предыдущее
От: Stefan Kaltenbrunner
Дата:
Сообщение: Re: SCSI vs SATA
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Can't drop tablespace or user after disk gone