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.
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
In response to
pgsql-novice by date
|Next:||From: slapo||Date: 2011-04-04 09:06:29|
|Subject: PostgreSQL 9.0.3 cannot choose the best candidate function with type casts|
|Previous:||From: mike lan||Date: 2011-03-30 18:50:00|
|Subject: migrate postgresql database from 8.3 to 8.4 version ?|