pg_dump, restore and versioning

From: sol <sol(at)autonomon(dot)net>
To: pgsql-novice(at)postgresql(dot)org
Subject: pg_dump, restore and versioning
Date: 2002-07-09 12:32:13
Message-ID: 3D2AD7CD.1080805@autonomon.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

I'm having a problem ever since restoring a database after a recent
server crash. Everytime I try restore the database from the dump file
the tuples are triplicated, that's including OID's. (If I "SELECT * FROM
mailing_list WHERE lastname like 'Somename';" I get three exact copies
of a record) This is not the result of a replication of values in the
dumpfile. I strongly suspect that the cause is because some editing was
done on the dumpfile in a Postgresql v7.1 db on another machine and the
server is running v6.5.

Are there any known issues with restoring dumpfiles from later versions
of Postgresql into earlier versions? If so - or if not for that matter -
is there any known way around this problem? Or is it time to upgrade?

kind regards,
sol

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Tom Lane 2002-07-09 13:59:19 Re: Network Connection Problem
Previous Message Juergen G. Mischke 2002-07-09 08:34:27 update problem?