Re: Upgrading from postgres 8.1 to 8.3

From: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
To: Scott Mead <scott(dot)lists(at)enterprisedb(dot)com>
Cc: glynastill(at)yahoo(dot)co(dot)uk, pgsql-general(at)postgresql(dot)org, S Arvind <arvindwill(at)gmail(dot)com>
Subject: Re: Upgrading from postgres 8.1 to 8.3
Date: 2009-05-07 19:10:17
Message-ID: dcc563d10905071210h77a9b7d1t3d51ee1767dfc475@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thu, May 7, 2009 at 1:05 PM, Scott Mead <scott(dot)lists(at)enterprisedb(dot)com> wrote:
>
> On Thu, May 7, 2009 at 2:56 PM, Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
> wrote:
>>
>> 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.
>
>   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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Anders Steinlein 2009-05-07 19:45:30 Schema per user?
Previous Message Scott Mead 2009-05-07 19:05:27 Re: Upgrading from postgres 8.1 to 8.3