Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-novice by date

Next:From: Kevin GrittnerDate: 2012-08-22 13:49:51
Subject: Re: Vacuum error message
Previous:From: Tom LaneDate: 2012-08-20 14:50:36
Subject: Re: Vacuum error message

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group