Postgress Database upgrade renders data unreadable
During one of the updates of Fedora, Postgres was upgraded. After not having used my Postgres datbases for some time I recently found that the data had at some stage become incompatible with one of the versions of Postgres.
The not so helpful advice is; to re-install an old version of Postgres do a database backup, upgrade Postgres and then reinstall the data. Even if this were not problematical it is time consuming.
Have these people ever experienced rpm hell? If you try to return to an old rpm, a long list of applications dependent on the newer rpm also have to be removed. Applications that I would rather remain on the computer. This is really annoying.
Does anyone know a way to convert the old Postgres database to the new format without ripping my poor computer's software to pieces.
This would be most helpful to many people I am sure.
Last edited by keirvt; 11-16-2007 at 04:04 PM.
|