Re: [GENERAL] Upgrading from postgres 8.1 to 8.3
On Thu, May 7, 2009 at 1:05 PM, Scott Mead wrote: > > On Thu, May 7, 2009 at 2:56 PM, Scott Marlowe > wrote: >> >> On Thu, May 7, 2009 at 4:54 AM, Glyn Astill >> wrote: >> > >> >> From: S Arvind >> >> 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. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Upgrading from postgres 8.1 to 8.3
On Thu, May 7, 2009 at 2:56 PM, Scott Marlowe wrote: > On Thu, May 7, 2009 at 4:54 AM, Glyn Astill > wrote: > > > >> From: S Arvind > >> 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 + http://momjian.us/main/blogs/pgblog.html#May_5_2009 --Scott > > > -- > Sent via pgsql-general mailing list (pgsql-general@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general >
Re: [GENERAL] Upgrading from postgres 8.1 to 8.3
On Thu, May 7, 2009 at 4:54 AM, Glyn Astill wrote: > >> From: S Arvind >> 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. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Upgrading from postgres 8.1 to 8.3
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 r...@iol.ie Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals -- -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Upgrading from postgres 8.1 to 8.3
> From: S Arvind > 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
[GENERAL] 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*