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