Re: Converting 7.x to 8.x - Mailing list pgsql-general

From Chris
Subject Re: Converting 7.x to 8.x
Date
Msg-id 45B83567.7050300@gmail.com
Whole thread Raw
In response to Converting 7.x to 8.x  (Carlos <CarlosO@pbsinet.com>)
Responses Re: Converting 7.x to 8.x
List 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/

pgsql-general by date:

Previous
From: Chris
Date:
Subject: Re: indexing primary and foreign keys w/lookup table
Next
From: "Merlin Moncure"
Date:
Subject: Re: indexing primary and foreign keys w/lookup table