From: Tom Lane <tgl@sss.pgh.pa.us>
To: Alexandre Leclerc <aleclerc@ipso.ca>
Cc: pgsql-admin@postgresql.org
Subject: Re: Vacuum Full (PG 8.1) - Urgent help needed - Cancel & transaction "liberation"
Date: Fri, 16 Apr 2010 10:46:02 -0400
Message-ID: <9048.1271429162@sss.pgh.pa.us> (raw)
In-Reply-To: <4BC8639C.4010202@ipso.ca>
References: <4BC8639C.4010202@ipso.ca>
Alexandre Leclerc <aleclerc@ipso.ca> writes:
> *Background:*
> - PostgreSQL 8.1 on Windows Server
> - The customer has disabled regular VACUUM jobs for backup to be taken,
> a year or two ago.
> - They didn't told us (as far as I can remember).
> - Wednesday morning at 10:55:50: database is shut down to avoid
> wraparound data loss in database *db*
> *What has been done:*
> - The message requested a VACUUM FULL so we stopped the postmaster and
> started postgres.exe to launch a VACUUM FULL.
You misread it. You do NOT need a VACUUM FULL here, you should just run
a plain VACUUM (across the whole database, ie not one per table). It
will take a lot less time.
After you get out of this, you really need to do something about
upgrading from 8.1, or else moving the server off Windows. 8.1 on
Windows is unsupported and is full of known problems for that platform.
regards, tom lane
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: tgl@sss.pgh.pa.us, aleclerc@ipso.ca
Subject: Re: Vacuum Full (PG 8.1) - Urgent help needed - Cancel & transaction "liberation"
In-Reply-To: <9048.1271429162@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox