Re: System crash and trying to run vacuum getting errors

Поиск
Список
Период
Сортировка
От Greg Stark
Тема Re: System crash and trying to run vacuum getting errors
Дата
Msg-id 87n0ba3ejc.fsf@stark.dyndns.tv
обсуждение исходный текст
Ответ на Re: System crash and trying to run vacuum getting errors  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
Tom Lane <tgl@sss.pgh.pa.us> writes:

> You should be able to DROP that table even though it doesn't have an
> underlying file.  My guess is that you are running atop a non-crash-safe
> filesystem and it lost the directory entry for the just-created file.
> You might want to think about switching to a journaling file system.

In which case you might find them in /lost+found


--
greg

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: System crash and trying to run vacuum getting errors
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Using SUBSELECT in CHECK expressions