Re: Dump 7.1.3->7.4.2

On Mon, May 31, 2004 at 07:57:01AM +0200, Cyril VELTER wrote:
>
> 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 ?)

What backend? 7.4-pg_dump will generate 7.4-backend's compatible
input, and the 7.1-backend does not interact at all --- save with
7.4-pg_dump, which will make itself understood easily ...

Lots of people (including me) use this procedure to upgrade rather
smoothly. What's your problem exactly?

--
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
"In a specialized industrial society, it would be a disaster
to have kids running around loose." (Paul Graham)