Re: Upgrading from postgres 8.1 to 8.3

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 +

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

--Scott

>
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>