Re: Vacuum error message - Mailing list pgsql-novice

From Kevin Grittner
Subject Re: Vacuum error message
Date
Msg-id 50349D2F02000025000499EC@gw.wicourts.gov
Whole thread Raw
In response to Re: Vacuum error message  (Raymond McKolay <RMcKolay@brittenbanners.com>)
Responses Re: Vacuum error message  (Raymond McKolay <RMcKolay@brittenbanners.com>)
List 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 by date:

Previous
From: Raymond McKolay
Date:
Subject: Re: Vacuum error message
Next
From: Raymond McKolay
Date:
Subject: Re: Vacuum error message