Upgrading from postgres 8.1 to 8.3

From: S Arvind <arvindwill@gmail.com>
Subject: [GENERAL] Upgrading from postgres 8.1 to 8.3
To: pgsql-general@postgresql.org
Date: Thursday, 7 May, 2009, 11:42 AM
Our 600GB data was currently loaded in postgres 8.1 , we
want to upgrade
from postgres 8.1 to 8.3 . Can we able to point the data
directly or should
we have to do any porting work for transfering data from
8.1 to 8.3.

You need to do a dump and reload. There was a project that did an in-place upgrade of datafiles (pg_migrator???) but I think it only supports -> 8.2

On 07/05/2009 11:42, S Arvind wrote:

Our 600GB data was currently loaded in postgres 8.1 , we want to upgrade
from postgres 8.1 to 8.3 . Can we able to point the data directly or should
we have to do any porting work for transfering data from 8.1 to 8.3.

You'll want to test your applications against the new version - one big
gotcha is the removal of certain automatic casts. It's well documented
in the release notes and in various threads on this list.

Ray.

------------------------------------------------------------------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
rod@iol.ie
Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals
------------------------------------------------------------------

On Thu, May 7, 2009 at 4:54 AM, Glyn Astill <glynastill@yahoo.co.uk> wrote:

From: S Arvind <arvindwill@gmail.com>
Subject: [GENERAL] Upgrading from postgres 8.1 to 8.3
To: pgsql-general@postgresql.org
Date: Thursday, 7 May, 2009, 11:42 AM
Our 600GB data was currently loaded in postgres 8.1 , we
want to upgrade
from postgres 8.1 to 8.3 . Can we able to point the data
directly or should
we have to do any porting work for transfering data from
8.1 to 8.3.

You need to do a dump and reload. There was a project that did an in-place upgrade of datafiles (pg_migrator???) but I think it only supports -> 8.2

Bruce is working on that project for 8.4 I believe.

On Thu, May 7, 2009 at 2:56 PM, Scott Marlowe <scott.marlowe@gmail.com>wrote:

On Thu, May 7, 2009 at 4:54 AM, Glyn Astill <glynastill@yahoo.co.uk>
wrote:

From: S Arvind <arvindwill@gmail.com>
Subject: [GENERAL] Upgrading from postgres 8.1 to 8.3
To: pgsql-general@postgresql.org
Date: Thursday, 7 May, 2009, 11:42 AM
Our 600GB data was currently loaded in postgres 8.1 , we
want to upgrade
from postgres 8.1 to 8.3 . Can we able to point the data
directly or should
we have to do any porting work for transfering data from
8.1 to 8.3.

You need to do a dump and reload. There was a project that did an

in-place upgrade of datafiles (pg_migrator???) but I think it only supports
-> 8.2

Bruce is working on that project for 8.4 I believe.

I think that one only supports 8.3 +

http://momjian.us/main/blogs/pgblog.html#May_5_2009

--Scott

On Thu, May 7, 2009 at 1:05 PM, Scott Mead <scott.lists@enterprisedb.com> wrote:

On Thu, May 7, 2009 at 2:56 PM, Scott Marlowe <scott.marlowe@gmail.com>
wrote:

On Thu, May 7, 2009 at 4:54 AM, Glyn Astill <glynastill@yahoo.co.uk>
wrote:

From: S Arvind <arvindwill@gmail.com>
Subject: [GENERAL] Upgrading from postgres 8.1 to 8.3
To: pgsql-general@postgresql.org
Date: Thursday, 7 May, 2009, 11:42 AM
Our 600GB data was currently loaded in postgres 8.1 , we
want to upgrade
from postgres 8.1 to 8.3 . Can we able to point the data
directly or should
we have to do any porting work for transfering data from
8.1 to 8.3.

You need to do a dump and reload. There was a project that did an
in-place upgrade of datafiles (pg_migrator???) but I think it only supports
-> 8.2

Bruce is working on that project for 8.4 I believe.

  I think that one only supports 8.3 +

Sorry if that came across as a reply to the OP about his issue, it was
more a comment to the replied to post that the upgrade project was
back alive. Didn't mean to cause confusion.