Re: DROP TABLESPACE fails

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: DROP TABLESPACE fails
Дата
Msg-id 24446.1155002257@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: DROP TABLESPACE fails  (Michael Fuhr <mike@fuhr.org>)
Список pgsql-general
Michael Fuhr <mike@fuhr.org> writes:
> On Mon, Aug 07, 2006 at 05:36:49PM -0500, Steve Peterson wrote:
>> DROP TABLESPACE x returns 'tablespace "x" is not empty', but if I
>> examine the 'referenced by' tab in pgAdmin nothing is listed.  The
>> tablespace directory contains several very large files.
>>
>> Can these files be deleted safely with the server shut down?

> I'd recommend investigating what the files are before deleting them.

Indeed.

> The large files are probably within a database's subdirectory and
> their names are probably numbers.

Yeah, most likely they belong to a different database.  We should try
harder to give a helpful error message in this case ... we can't really
identify the files but we could tell you which database they belong to.

            regards, tom lane

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: FATAL Error
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Disabling and enabling constraints and triggers to make pg_restore work