Re: vacuum error

On Wed, Mar 07, 2007 at 07:07:45PM -0700, Ed L. wrote:
> How would I go about correctly creating the missing file?  That 
> sounds appealing, as if it were something I could do without 
> taking downtime.  Is it?

Depends if it's because the file got deleted prematurly, or because
it's the result of corruption in the table. If it's just that it got
deleted prematurely, you should just be able to create the file with
256KB of zeros.

> In reviewing the release notes between 8.1.2 and 8.1.8, there are 
> a number of vacuum fixes along with many others.  It is unclear 
> if any of them are related.

There definitly was a bug related to this and you should upgrade to the
latest minor release anyway, because it will probably bite you again.

> Given this error is occurring while doing a "VACUUM FREEZE" of 
> the template0 database, I wonder if that creates any options for 
> me?  Frankly, I'd be happy to simply drop the template0 DB if I 
> could, since I'm not aware that we ever need it for anything.

You can drop and recreate the template0 database, instructions are
somewhere. I don't think you can do without because I beleive pg_dump
needs it.

Have a nice day,
-- 
Martijn van Oosterhout      http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to litigate.