Обсуждение: migrate postgresql database from 8.3 to 8.4 version ?

On Wed, 2011-03-30 at 18:50 +0000, 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 ?

Everything is possible, if you have already tested your application. 8.2
to 8.3 is likely to break, because of casting changes. The rul1e of the
thumb is taking the dump using the higher version of pg_dump.

If you want to move from 8.4 to 9.0 (the only combination that you did
not specify, but still...), you can also use pg_upgrade utility.

Regards,
--
Devrim GÜNDÜZ
Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com
PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
http://www.gunduz.org  Twitter: http://twitter.com/devrimgunduz

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.kumar@enterprisedb.com
Blog:http://vibhork.blogspot.com