Re: Converting 7.x to 8.x

From: Chris <dmagick(at)gmail(dot)com>
To: Carlos <CarlosO(at)pbsinet(dot)com>
Cc: "'pgsql-general(at)postgresql(dot)org'" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Converting 7.x to 8.x
Date: 2007-01-25 04:43:19
Message-ID: 45B83567.7050300@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Carlos wrote:
> What would be the faster way to convert a 7.4.x database into an 8.x
> database? A dump of the database takes over 20 hours so we want to
> convert the database without having to do a dump and resptore.

That's your only option as far as I know (I'm sure someone will correct
me if that's not the case).

You can't do a binary conversion or anything like that because the
postgres internals are different between major versions.

--
Postgresql & php tutorials
http://www.designmagick.com/

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Merlin Moncure 2007-01-25 04:44:30 Re: indexing primary and foreign keys w/lookup table
Previous Message Chris 2007-01-25 04:40:57 Re: indexing primary and foreign keys w/lookup table