pg_dump, restore and versioning
| От | sol |
|---|---|
| Тема | pg_dump, restore and versioning |
| Дата | |
| Msg-id | 3D2AD7CD.1080805@autonomon.net обсуждение исходный текст |
| Ответы |
Re: pg_dump, restore and versioning
|
| Список | 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
В списке pgsql-novice по дате отправления: