Re: Vacuum error message

Поиск
Список
Период
Сортировка
От Kevin Grittner
Тема Re: Vacuum error message
Дата
Msg-id 50349D2F02000025000499EC@gw.wicourts.gov
обсуждение исходный текст
Ответ на Re: Vacuum error message  (Raymond McKolay <RMcKolay@brittenbanners.com>)
Ответы Re: Vacuum error message  (Raymond McKolay <RMcKolay@brittenbanners.com>)
Список pgsql-novice
Raymond McKolay <RMcKolay@brittenbanners.com> wrote:

>>> The 16396 is a directory under the postgresql/data/base path and
>>> within it are file files named 16768, 16768.1, 16768.2, 16768.3
>>> and 16768.4
>>
>> And can you copy those somewhere else?
>
> I moved the files to the desktop of the server [...] and the same
> error message still comes up.

I'm not sure what you mean by "moved" -- the point was to copy the
contents of the files so that you could determine whether the OS
could read all the pages in the file.  Under some definitions of
"move" you would only have touched the directory entries for the
files, which wouldn't give us the information we were looking for.

> Do I need more free space on the server than what the size of the
> DB is in order to Vacuum the DB?

A normal vacuum of the database doesn't require much (if any) disk
space.  VACUUM FULL is another story, but you probably don't want to
go there.

-Kevin


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

Предыдущее
От: Raymond McKolay
Дата:
Сообщение: Re: Vacuum error message
Следующее
От: Raymond McKolay
Дата:
Сообщение: Re: Vacuum error message