Re: Vacuum error message

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Raymond McKolay <RMcKolay(at)brittenbanners(dot)com>
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-20 14:50:36
Message-ID: 29899.1345474236@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Raymond McKolay <RMcKolay(at)brittenbanners(dot)com> writes:
> 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.

Yeah, sorry, 1663 is the OID of the pg_default tablespace, so it
corresponds to the data/base/ directory.

> 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?

regards, tom lane

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Raymond McKolay 2012-08-22 12:31:25 Re: Vacuum error message
Previous Message Raymond McKolay 2012-08-20 13:17:55 Re: Vacuum error message