Skip site navigation (1) Skip section navigation (2)

Re: migrate postgresql database from 8.3 to 8.4 version ?

From: Devrim GÜNDÜZ <devrim(at)gunduz(dot)org>
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-03-30 18:58:49
Message-ID: 1301511529.7735.5.camel@lenovo01-laptop03.gunduz.org (view raw or flat)
Thread:
Lists: pgsql-novice
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

In response to

pgsql-novice by date

Next:From: slapoDate: 2011-04-04 09:06:29
Subject: PostgreSQL 9.0.3 cannot choose the best candidate function with type casts
Previous:From: mike lanDate: 2011-03-30 18:50:00
Subject: migrate postgresql database from 8.3 to 8.4 version ?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group