Received: from maia.hub.org (unknown [200.46.208.211]) by mail.postgresql.org (Postfix) with ESMTP id 364FC6322C2 for ; Fri, 16 Apr 2010 11:46:16 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024) with ESMTP id 03295-02 for ; Fri, 16 Apr 2010 14:45:55 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by mail.postgresql.org (Postfix) with ESMTP id 775FB632298 for ; Fri, 16 Apr 2010 11:46:05 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.2/8.14.2) with ESMTP id o3GEk2NF009049; Fri, 16 Apr 2010 10:46:02 -0400 (EDT) To: Alexandre Leclerc cc: pgsql-admin@postgresql.org Subject: Re: Vacuum Full (PG 8.1) - Urgent help needed - Cancel & transaction "liberation" In-reply-to: <4BC8639C.4010202@ipso.ca> References: <4BC8639C.4010202@ipso.ca> Comments: In-reply-to Alexandre Leclerc message dated "Fri, 16 Apr 2010 09:18:20 -0400" Date: Fri, 16 Apr 2010 10:46:02 -0400 Message-ID: <9048.1271429162@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-2.116 tagged_above=-10 required=5 tests=AWL=-0.206, BAYES_00=-1.9, T_RP_MATCHES_RCVD=-0.01 X-Spam-Level: X-Archive-Number: 201004/214 X-Sequence-Number: 34308 Alexandre Leclerc 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