Message-ID: <4BC6273B.3000803@setonhome.org>
Date: Wed, 14 Apr 2010 16:36:11 -0400
From: Lewis Kapell <lkapell@setonhome.org>
Organization: Seton Home Study School
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US;
	rv:1.9.1.9) Gecko/20100317 Lightning/1.0b1 Thunderbird/3.0.4
MIME-Version: 1.0
To: pgsql-admin@postgresql.org
Subject: Re: Migrating from 8.3 to 8.4 on the same server
References: <4BC5FB73.9@setonhome.org> <1271276908.2780.39.camel@deimos>
In-Reply-To: <1271276908.2780.39.camel@deimos>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit

The database is about 12gb, the dump file is about 8gb.

I tested dump/restore into 8.4 on our test server, and it took an hour. 
  This is a virtualized server, but my sysadmin thinks the performance 
on our live server (not virtual) would be comparable.

It wouldn't kill us to have two or three hours of down time, but I would 
like to avoid it.

Thank you,

Lewis Kapell
Computer Operations
Seton Home Study School


On 4/14/2010 4:28 PM, Iñigo Martinez Lasala wrote:
> How big is your database?
>
> If not very big, a pg_dump/pg_restore will be your best option. 8.3 to
> 8.4 is not a traumatic upgrade. In fact, it's really easy and probably
> you won't need to change your database schema.
> And pg_restore in 8.4 is really FAST (compared with previous versions).