pg_dump version conflict

From: Tom Haddon <tom(at)betterhealthfoundation(dot)org>
To: pgsql-admin(at)postgresql(dot)org
Subject: pg_dump version conflict
Date: 2003-03-25 21:54:41
Message-ID: 1048629281.21901.17.camel@penny.betterhealthfoundation.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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
______________________________

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Andrew Sullivan 2003-03-25 22:18:11 Re: pg_dump version conflict
Previous Message ashwini sridhar 2003-03-25 21:11:38 unsubscribe