On 26/01/07, Jim Nasby <decibel@decibel.org> wrote:
> On Jan 25, 2007, at 12:47 PM, Benjamin Smith wrote:
> > 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.
>
> In case no one's mentioned it already, you can also perform this
> migration using Slony, by making the 7.4 database the master, and
> replicating to an 8.x database.
In case this is not what you meant above, you can pipe a dump directly
into psql, so that keeps it to only 20hrs...
Cheers
Antoine