Re: Upgrading from postgres 8.1 to 8.3

On Thu, May 7, 2009 at 4:54 AM, Glyn Astill <glynastill(at)yahoo(dot)co(dot)uk> wrote:
>
>> From: S Arvind <arvindwill(at)gmail(dot)com>
>> Subject: [GENERAL] Upgrading from postgres 8.1 to 8.3
>> To: pgsql-general(at)postgresql(dot)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.