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: | 20040531131336.GB2552@dcc.uchile.cl |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
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]dcc.uchile.cl>)
"In a specialized industrial society, it would be a disaster
to have kids running around loose." (Paul Graham)
From | Date | Subject | |
---|---|---|---|
Next Message | Jeff Eckermann | 2004-05-31 14:20:48 | Re: ODBC, ADO, Return Value from SP problem |
Previous Message | Pavel Stehule | 2004-05-31 13:09:55 | ODBC, ADO, Return Value from SP problem |