Re: Upgrading from postgres 8.1 to 8.3

From: Glyn Astill <glynastill(at)yahoo(dot)co(dot)uk>
To: 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 10:54:30
Message-ID: 288440.68940.qm@web23601.mail.ird.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


> 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Markus Wollny 2009-05-07 11:37:00 Question about function returning record
Previous Message S Arvind 2009-05-07 10:42:56 Upgrading from postgres 8.1 to 8.3