pg_dump version conflict - Mailing list pgsql-admin

From Tom Haddon
Subject pg_dump version conflict
Date
Msg-id 1048629281.21901.17.camel@penny.betterhealthfoundation.net
Whole thread Raw
Responses Re: pg_dump version conflict
List pgsql-admin
Hi Folks,

I'm trying to move from version 7.2.4 to version 7.1.2. May seem
counterintuitive, but trust me, there's a reason.

Anyway, the problem I'm having is that the pg_dump file from
pg_dump_7.2.4 doesn't seem to to work with 7.1.2 when I try to restore.
And when I try using pg_dump_7.1.2 to dump from the 7.2.4 database, I
get the following error message:

Database version: PostgreSQL 7.2.4 on i686-pc-linux-gnu, compiled by
GCC 2.96
Archiver(db) version: 7.1.2
Proceeding despite version mismatch.
getTables(): SELECT (for PRIMARY KEY) failed on table administrators.
 Explanation from backend: ERROR:  Attribute 'oid' not found


Is there any way round this? Or is there a better way to move from 7.2.4
to 7.1.2?

Thanks, Tom

--
______________________________
Tom Haddon
The Better Health Foundation
www.betterhealthfoundation.org
510.444.5096
______________________________


pgsql-admin by date:

Previous
From: ashwini sridhar
Date:
Subject: unsubscribe
Next
From: Andrew Sullivan
Date:
Subject: Re: pg_dump version conflict