Re: Vacuum Full (PG 8.1) - Urgent help needed - Cancel & transaction "liberation"

From: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
To: Alexandre Leclerc <aleclerc(at)ipso(dot)ca>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Vacuum Full (PG 8.1) - Urgent help needed - Cancel & transaction "liberation"
Date: 2010-04-16 23:19:47
Message-ID: n2pdcc563d11004161619rbce3a6aamcbb030cea2e0d4a2@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Fri, Apr 16, 2010 at 2:57 PM, Alexandre Leclerc <aleclerc(at)ipso(dot)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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Bryan White 2010-04-17 16:31:21 pg_restore error
Previous Message Jose Berardo 2010-04-16 21:08:17 Re: PostgreSQL with SSL