Re: Dump 7.1.3->7.4.2 - Mailing list pgsql-general

From Doug McNaught
Subject Re: Dump 7.1.3->7.4.2
Date
Msg-id 87pt8o9k3f.fsf@asmodeus.mcnaught.org
Whole thread Raw
In response to Dump 7.1.3->7.4.2  ("Cyril VELTER" <cyril.velter@metadys.com>)
List pgsql-general
"Cyril VELTER" <cyril.velter@metadys.com> writes:

>     I'm trying to dump a database from a 7.1.3 server to a 7.4.2 one.
>
>     It doesn't works because of difference in COPY format (unless I use -d
> which is VERY slow on a 16G database).

Try using the 7.4.2 version of pg_dump to dump out the 7.1.3
database.  pg_dump is written to talk to multiple versions of the
server, and it's generally recommended to use the same version of
pg_dump as the server you're restoring into.

-Doug

pgsql-general by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: postgresql anonymous cvs?
Next
From: Alexander Cohen
Date:
Subject: Re: turn WAL off.