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

Re: Dump 7.1.3->7.4.2

From: Alvaro Herrera <alvherre(at)dcc(dot)uchile(dot)cl>
To: Cyril VELTER <cyril(dot)velter(at)metadys(dot)com>
Cc: Doug McNaught <doug(at)mcnaught(dot)org>, pgsql-general(at)postgresql(dot)org
Subject: Re: Dump 7.1.3->7.4.2
Date: 2004-05-31 13:13:36
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-general
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]>)
"In a specialized industrial society, it would be a disaster
to have kids running around loose." (Paul Graham)

In response to


pgsql-general by date

Next:From: Jeff EckermannDate: 2004-05-31 14:20:48
Subject: Re: ODBC, ADO, Return Value from SP problem
Previous:From: Pavel StehuleDate: 2004-05-31 13:09:55
Subject: ODBC, ADO, Return Value from SP problem

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