Re: migrate postgresql database from 8.3 to 8.4 version ?

From: Vibhor Kumar <vibhor(dot)kumar(at)enterprisedb(dot)com>
To: mike lan <lan(dot)mike88(at)gmail(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: migrate postgresql database from 8.3 to 8.4 version ?
Date: 2011-04-04 12:24:36
Message-ID: 0DD3CB39-14F4-49F3-B2C3-C4EE22082221@enterprisedb.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice


On Mar 31, 2011, at 12:20 AM, mike lan wrote:

> is it possible to migrate postgresql database from 8.3 to 8.4 version ?
> what about 8.3 to 9 ?
> 8.2 to 8.3 ?

Yes it is possible. You can use slony, pg_dump/pg_restore and for 8.4 -> to 9.0 you can use pg_upgrade utility too. However, I would recommend to test your application before migration and go through the release notes too.

Thanks & Regards,
Vibhor Kumar
EnterpriseDB Corporation
The Enterprise PostgreSQL Company
vibhor(dot)kumar(at)enterprisedb(dot)com
Blog:http://vibhork.blogspot.com

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message aaronenabs 2011-04-04 14:32:28 pg_dump
Previous Message slapo 2011-04-04 09:06:29 PostgreSQL 9.0.3 cannot choose the best candidate function with type casts