Re: Vacuum error message

From: Raymond McKolay <RMcKolay(at)brittenbanners(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Kevin Grittner <Kevin(dot)Grittner(at)wicourts(dot)gov>, "pgsql-novice(at)postgresql(dot)org" <pgsql-novice(at)postgresql(dot)org>
Subject: Re: Vacuum error message
Date: 2012-08-22 12:31:25
Message-ID: 04DF6FA1889A244FAD25273E58CD65AA035436A5D6@email
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

> 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 changed the max_fsm_pages to 819200 and the same error message still comes up.
Do I need more free space on the server than what the size of the DB is in order to Vacuum the DB?
The reason I changed the fsm_pages vaule was due to a hint in the message log.

Ray

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Kevin Grittner 2012-08-22 13:49:51 Re: Vacuum error message
Previous Message Tom Lane 2012-08-20 14:50:36 Re: Vacuum error message