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

From Benjamin Smith
Subject Re: Converting 7.x to 8.x
Date
Msg-id 200701251047.25161.lists@benjamindsmith.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
On Tuesday 23 January 2007 13:55, 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.

You've probably already accounted for this, but make sure you've tried your
options for loading the database. Using long ("insert") form vs copy can make
a *huge* performance difference.

(Hours vs seconds, in some cases!)

-Ben
--
"The best way to predict the future is to invent it."
- XEROX PARC slogan, circa 1978

pgsql-general by date:

Previous
From: Benjamin Smith
Date:
Subject: Re: sequence increment jumps?
Next
From: Douglas McNaught
Date:
Subject: Re: sequence increment jumps?