Message-ID: <4BCC53A7.7050308@ipso.ca>
Date: Mon, 19 Apr 2010 08:59:19 -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
CC: pgsql-admin@postgresql.org
Subject: Re: Vacuum Full (PG 8.1) - Urgent help needed - Cancel &
	transaction "liberation"
References: <4BC8639C.4010202@ipso.ca> <4BC8A623.8090201@ipso.ca>	
	<4BC8638E0200002500030A01@gw.wicourts.gov>
	<4BC8B0CE.2010401@ipso.ca>	
	<1271444725.21263.80.camel@jd-desktop.unknown.charter.com>	
	<4BC871F90200002500030A0D@gw.wicourts.gov>	
	<13971.1271447063@sss.pgh.pa.us> <4BC8C0D3.70406@ipso.ca>	
	<14487.1271448871@sss.pgh.pa.us> <4BC8CF3E.7000205@ipso.ca>
	<n2pdcc563d11004161619rbce3a6aamcbb030cea2e0d4a2@mail.gmail.com>
In-Reply-To: <n2pdcc563d11004161619rbce3a6aamcbb030cea2e0d4a2@mail.gmail.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 8bit

Le 2010-04-16 19:19, Scott Marlowe a écrit :
> On Fri, Apr 16, 2010 at 2:57 PM, Alexandre Leclerc<aleclerc@ipso.ca>  wrote:
>    
>> Thank you guys. I wanted to rush and vacuum the other tables and try, but I
>> decided to make a copy. This is actually running. (Enough mistakes in one
>> day to not take the time to do it.)
>>
>> After that we try to launch the DB and hopefully it will be working good
>> enough before the next maintenance. Else, a big week-end is coming.
>>      
> Don't forget to schedule an upgrade to at least 8.2 since 8.1 is
> considered  broken and unsupported / unsupportable on windows.  8.3
> changes some casting behaviour so you might want to wait until you can
> test / fix code to go there, but 8.2 is usually a painless upgrade
> from 8.1
>    

Thank you Scott for this note.

I wanted to give some feedback on the situation:

- The vacuum completed after about 6-7 hours (by 16:15 PM). We 
immediately made a backup before proceeding further. Then we vacuumed 
the postgres et template1 databases.

- We were then successful at restarting postmaster and working with the 
database. Everything works as expected.

Among all the help received (thank you all) I want to specially thank 
Kevin and Tom for their excellent help and time through this urgent 
problem we had to fix. I want to underline their detailed and precise 
posts that were of great value for acting and taking decisions to 
recover the DB. Thank you guys!

Again, thank you to all.

Best regards,

-- 
Alexandre Leclerc