Red Hat Bugzilla – Bug 460074
unacceptable data loss (unconvertability) on upgrading
Last modified: 2013-07-02 23:19:08 EDT
Upon a recent update to fedora 9 that included a bump to postgresql
(8.3.3-2.fc9), I was shocked to find that the data migration widgets
formerly in the rpm spec file have been disabled. Now my data is dead
and inaccessible unless I somehow reinstall the previous version of
postgresql by hand, dump the data, update postgresql again, and then
This is unacceptable.
Some possible fixes:
- the automagic rpm data migration script should be brought back
- postgresql should be fixed to migrate its own old data files
- postgresql rpm should forbid updating itself -- probably
also possible with a simple rpm spec hack %pre_inst
AFAIK there have never been any "data migration widgets" in any postgres RPM shipped by Red Hat. I know some other distros have tried to handle that automagically, but it generally doesn't work very well --- running arbitrary code in a scriptlet is a bad idea.
Upstream is aware that upgrade-in-place would be a nice thing to have, but it's a hard problem...
*** This bug has been marked as a duplicate of bug 398221 ***