Обсуждение: Upgrading from postgres 8.1 to 8.3
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.
Arvind S
"Many of lifes failure are people who did not realize how close they were to success when they gave up."
-Thomas Edison
Arvind S
"Many of lifes failure are people who did not realize how close they were to success when they gave up."
-Thomas Edison
> 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
On 07/05/2009 11:42, S Arvind wrote: > 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'll want to test your applications against the new version - one big gotcha is the removal of certain automatic casts. It's well documented in the release notes and in various threads on this list. Ray. ------------------------------------------------------------------ Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland rod@iol.ie Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals ------------------------------------------------------------------
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 Ithink it only supports -> 8.2 Bruce is working on that project for 8.4 I believe.
On Thu, May 7, 2009 at 2:56 PM, Scott Marlowe <scott.marlowe@gmail.com> wrote:
On Thu, May 7, 2009 at 4:54 AM, Glyn Astill <glynastill@yahoo.co.uk> wrote:Bruce is working on that project for 8.4 I believe.
>
>> 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
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Thu, May 7, 2009 at 1:05 PM, Scott Mead <scott.lists@enterprisedb.com> wrote: > > On Thu, May 7, 2009 at 2:56 PM, Scott Marlowe <scott.marlowe@gmail.com> > wrote: >> >> 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. > > 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.