pg.ddx.io pgsql-admin@postgresql.org mailing list archivehelp / color / mirror / Atom feed
From: Iñigo Martinez Lasala <imartinez@vectorsf.com>
To: Lewis Kapell <lkapell@setonhome.org>
Cc: pgsql-admin@postgresql.org
Subject: Re: Migrating from 8.3 to 8.4 on the same server
Date: Wed, 14 Apr 2010 23:10:50 +0200
Message-ID: <1271279450.2780.50.camel@deimos> (raw)
In-Reply-To: <4BC6273B.3000803@setonhome.org>
References: <4BC5FB73.9@setonhome.org>
<1271276908.2780.39.camel@deimos>
<4BC6273B.3000803@setonhome.org>
I've never tested pg_migrator... it appears a good candidate for your
upgrade, although I think it will work over datafiles, so test it
carefully with a replica of your database.
Slony is always an option. It's not very difficult to deploy, but you
have to manually create the schema in target database and all tables
must include a primary key or an unique index. So, it's not fire and
forget. :-)
We have recently migrated our Gforge database from 8.1 to 8.4. It took
about 50 minutes for dump (20GB database into a 7.8GB dump) and 40
minutes for restore. You can speed your restore process if you restore
first your schema WITHOUT indexes, then restore data, and finally create
indexes.
-----Original Message-----
From: Lewis Kapell <lkapell@setonhome.org>
To: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] Migrating from 8.3 to 8.4 on the same server
Date: Wed, 14 Apr 2010 16:36:11 -0400
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).
view thread (10+ messages) latest in thread
Message-ID: <1271279450.2780.50.camel@deimos> Permalink: ../1271279450.2780.50.camel@deimos/ Also on: postgresql.org/message-id/1271279450.2780.50.camel@deimos ·
reply
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: imartinez@vectorsf.com, lkapell@setonhome.org Subject: Re: Migrating from 8.3 to 8.4 on the same server In-Reply-To: <1271279450.2780.50.camel@deimos> * 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