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

Re: Dump 7.1.3->7.4.2

From: "Cyril VELTER" <cyril(dot)velter(at)metadys(dot)com>
To: "Doug McNaught" <doug(at)mcnaught(dot)org>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: Dump 7.1.3->7.4.2
Date: 2004-05-31 05:57:01
Message-ID: 0eb001c446d4$559a4080$dc01a8c0@lodgis.net (view raw or flat)
Thread:
Lists: pgsql-general
From: "Doug McNaught" <doug(at)mcnaught(dot)org>


> "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.

    That's what I already do, but the problem is in COPY TO format (which is
handled by the backend ? right ?)

    cyril


In response to

Responses

pgsql-general by date

Next:From: AgoDate: 2004-05-31 08:17:44
Subject: Separating application from data
Previous:From: Jurgen DefurneDate: 2004-05-31 05:28:19
Subject: Re: Error handling in stored functions/procedures

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