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

Re: - Upgrade advice

From: Alan Hodgson <ahodgson(at)simkin(dot)ca>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: - Upgrade advice
Date: 2011-06-03 17:27:13
Message-ID: 201106031027.13691@hal.medialogik.com (view raw or flat)
Thread:
Lists: pgsql-novice
On June 3, 2011, fel <fellsin(at)hotmail(dot)com> wrote:
> What would be the best solution :
> - Dump data from 32bit to 64bit then upgrade to v9.0 (using pg_upgrade).
> - Upgrade to v9.0 then dump from 32 to 64bit.
> - Dump from 8.3-32bit to 9.0-64bit.

Just dump from 8.3-32bit to 9.0-64bit. Pay attention to the various 
changelogs in case your application will be affected by functionality 
changes.

The only reason to do pg_upgrade is to avoid a dump/reload cycle, but that 
isn't an option in your case (at least, I'm pretty sure it isn't).

In response to

pgsql-novice by date

Next:From: Josh KupershmidtDate: 2011-06-04 03:01:10
Subject: Re: BYTEA index
Previous:From: felDate: 2011-06-03 10:17:23
Subject: - Upgrade advice

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