pg_dump issue across different versions (7.1.2 & 7.2). - Mailing list pgsql-admin

From Bhuvan A
Subject pg_dump issue across different versions (7.1.2 & 7.2).
Date
Msg-id Pine.LNX.4.20.0203091145380.16096-100000@Larry
Whole thread Raw
Responses Re: pg_dump issue across different versions (7.1.2 & 7.2).  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-admin
hi,

here i have 2 machines which have postgres 7.1.2 & 7.2 running,
respectively.  I did try pg_dump of database in machine (7.2) from the
machine where i have 7.1.2 and it produced the message

Archiver(db) version: 7.1
Aborting because of version mismatch.
Use --ignore-version if you think it's safe to proceed anyway.

so i did try with the option '--ignore-version', then it produced

Archiver(db) version: 7.1
Proceeding despite version mismatch.
getTables(): SELECT (for PRIMARY KEY) failed on table
address.  Explanation from backend: ERROR:  Attribute 'oid' not found

---

what seems to be the problem here?? how could i overcome this problem?
one way is to dump in corresponding machine. any other way?

any valuable suggestions are very welcome at the earliest, please!


Regards,
Bhuvaneswaran.


pgsql-admin by date:

Previous
From: Joe Conway
Date:
Subject: Re: column name length
Next
From: Tom Lane
Date:
Subject: Re: pg_dump issue across different versions (7.1.2 & 7.2).