Skip site navigation (1) Skip section navigation (2)

Re: Dump 7.1.3->7.4.2

From: Doug McNaught <doug(at)mcnaught(dot)org>
To: "Cyril VELTER" <cyril(dot)velter(at)metadys(dot)com>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: Dump 7.1.3->7.4.2
Date: 2004-05-29 00:02:12
Message-ID: 87pt8o9k3f.fsf@asmodeus.mcnaught.org (view raw or flat)
Thread:
Lists: pgsql-general
"Cyril VELTER" <cyril(dot)velter(at)metadys(dot)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

In response to

Responses

pgsql-general by date

Next:From: Alexander CohenDate: 2004-05-29 01:25:16
Subject: Re: turn WAL off.
Previous:From: Alvaro HerreraDate: 2004-05-28 22:14:25
Subject: Re: postgresql anonymous cvs?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group