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 I think it only supports -> 8.2
Bruce is working on that project for 8.4 I believe.