Postgres Pro
Downloads
Home   >   mailing lists

Re: Upgrading from postgres 8.1 to 8.3 - Mailing list pgsql-general

From Glyn Astill
Subject Re: Upgrading from postgres 8.1 to 8.3
Date
Msg-id 288440.68940.qm@web23601.mail.ird.yahoo.com
Whole thread Raw
In response to Upgrading from postgres 8.1 to 8.3  (S Arvind <arvindwill@gmail.com>)
Responses Re: Upgrading from postgres 8.1 to 8.3  (Scott Marlowe <scott.marlowe@gmail.com>)
List pgsql-general
Tree view 
> 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
thinkit only supports -> 8.2

pgsql-general by date:

Previous
From: Conrad Lender
Date:
Subject: "No transaction in progress" warning
Next
From: "Markus Wollny"
Date:
Subject: Question about function returning record