From: Alexandre Leclerc <aleclerc@ipso.ca>
Cc: pgsql-admin@postgresql.org
Subject: Re: Vacuum Full (PG 8.1) - Urgent help needed - Cancel & transaction "liberation"
Date: Mon, 19 Apr 2010 08:59:19 -0400
Message-ID: <4BCC53A7.7050308@ipso.ca> (raw)
In-Reply-To: <n2pdcc563d11004161619rbce3a6aamcbb030cea2e0d4a2@mail.gmail.com>
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>
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
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: aleclerc@ipso.ca
Subject: Re: Vacuum Full (PG 8.1) - Urgent help needed - Cancel & transaction "liberation"
In-Reply-To: <4BCC53A7.7050308@ipso.ca>
* 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