Message-ID: <4BC8A825.3030006@ipso.ca>
Date: Fri, 16 Apr 2010 14:10:45 -0400
From: Alexandre Leclerc <aleclerc@ipso.ca>
Organization: Ipso Technologies
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; fr;
	rv:1.9.1.9) Gecko/20100317 Thunderbird/3.0.4
MIME-Version: 1.0
To: Tom Lane <tgl@sss.pgh.pa.us>
CC: pgsql-admin@postgresql.org
Subject: Re: Vacuum Full (PG 8.1) - Urgent help needed - Cancel &
	transaction "liberation"
References: <4BC8639C.4010202@ipso.ca> <9048.1271429162@sss.pgh.pa.us>
In-Reply-To: <9048.1271429162@sss.pgh.pa.us>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 8bit

Hi again,

I also want to mention that maybe I'm not doing it properly.

I started "postgres.exe" and it is inside that "session", "backend>" 
prompt, that I did run the VACUUM command. Is it that way or should I 
use psql to connect to anything "postgres.exe" would have "done" (like 
listening to a port?).

(And by the way, what is the command to quit the backend? I'm doing 
Ctrl+C but the DB does not like that...)

Best regards,
Alexandre Leclerc


Le 2010-04-16 10:46, Tom Lane a écrit :
> 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
>
>    

-- 
Alexandre Leclerc