Re: Upgrading from postgres 8.1 to 8.3 - Mailing list pgsql-general

From Scott Marlowe
Subject Re: Upgrading from postgres 8.1 to 8.3
Date
Msg-id dcc563d10905071156q66488ac0o491b7c1270de08fa@mail.gmail.com
Whole thread Raw
In response to Re: Upgrading from postgres 8.1 to 8.3  (Glyn Astill <glynastill@yahoo.co.uk>)
Responses Re: Upgrading from postgres 8.1 to 8.3  (Scott Mead <scott.lists@enterprisedb.com>)
List pgsql-general
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
Ithink it only supports -> 8.2 

Bruce is working on that project for 8.4 I believe.

pgsql-general by date:

Previous
From: Marco Maccaferri
Date:
Subject: Re: Postgres partially hang after inactivity
Next
From: John R Pierce
Date:
Subject: Re: Optimizing tuning and table design for large analytics DB