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)
In response to
pgsql-general by date
|Next:||From: Jeff Eckermann||Date: 2004-05-31 14:20:48|
|Subject: Re: ODBC, ADO, Return Value from SP problem|
|Previous:||From: Pavel Stehule||Date: 2004-05-31 13:09:55|
|Subject: ODBC, ADO, Return Value from SP problem|