Re: Migrating from 8.3 to 8.4 on the same server

From: Lewis Kapell <lkapell(at)setonhome(dot)org>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: Migrating from 8.3 to 8.4 on the same server
Date: 2010-04-15 13:37:02
Message-ID: 4BC7167E.2080504@setonhome.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin


On 4/14/2010 5:11 PM, Greg Sabino Mullane wrote:
> If it wouldn't kill you, I'd suck up the time. All other solutions
> are going to take additional expertise, prep, and testing.
>
> Keep in mind that if you have tables and/or databases that don't
> change frequently, you can dump those beforehand to minimize
> the final downtime.

That's true, I had thought about that also. I guess I would save the
contents of the biggest tables to flat files using the COPY command,
then delete the copied rows, before doing the dump. Is what what you
had in mind?

Lewis

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Lewis Kapell 2010-04-15 14:37:27 Re: Query is stuck
Previous Message Satish Burnwal (sburnwal) 2010-04-15 13:31:41 Re: Query is stuck