Re: Vacuum error message

The filesystem is HFS+
And here is where my lack of knowledge of postgresql comes into play.
When you say copy the identified file what file are you referring too? Are you referring to the 1663/16396/16768? If so the file 1663 is nowhere to be found within any directories under the postgresql/data/base/ path. 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

Also I did find this message in the postgesql message log
Relation "pg_catalog.pg_largeobject" contains more than "max_fsm_pages" pages with useful free space.
Hint: consider using VACUUM FULL on the relation or increasing the configuration parameter "max_fsm_pages".

I'm not sure if that is referring to the free disk space on the server or something else.
The current value for the max_fsm_pages is 204800.

Thanks for all the help
Ray

-----Original Message-----
From: Kevin Grittner [mailto:Kevin(dot)Grittner(at)wicourts(dot)gov]
Sent: Friday, August 17, 2012 5:22 PM
To: Raymond McKolay; pgsql-novice(at)postgresql(dot)org
Subject: RE: [NOVICE] Vacuum error message

Raymond McKolay <RMcKolay(at)brittenbanners(dot)com> wrote:

> "version";"PostgreSQL 8.3.5 on powerpc-apple-darwin, compiled by GCC
> i686-apple-darwin8-gcc-4.0.1 (GCC) 4.0.1 (Apple Computer, Inc.
> build 5370)"

Tom suggested this might be from filesystem corruption and suggested you try to copy the identified file to somewhere else as a diagnostic step. Let us know how that goes. Oh, and please let us know what type of filesystem it is on.

-Kevin