| 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: | Whole Thread | Raw Message | 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
| 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? |