Bug 460074 - unacceptable data loss (unconvertability) on upgrading
Summary: unacceptable data loss (unconvertability) on upgrading
Keywords:
Status: CLOSED DUPLICATE of bug 398221
Alias: None
Product: Fedora
Classification: Fedora
Component: postgresql
Version: 9
Hardware: All
OS: Linux
medium
medium
Target Milestone: ---
Assignee: Tom Lane
QA Contact: Fedora Extras Quality Assurance
URL:
Whiteboard:
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2008-08-26 01:54 UTC by Frank Ch. Eigler
Modified: 2013-07-03 03:19 UTC (History)
1 user (show)

Fixed In Version:
Clone Of:
Environment:
Last Closed: 2008-08-26 02:51:48 UTC
Type: ---
Embargoed:


Attachments (Terms of Use)

Description Frank Ch. Eigler 2008-08-26 01:54:58 UTC
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
restore.

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

Comment 1 Tom Lane 2008-08-26 02:51:48 UTC
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 ***


Note You need to log in before you can comment on or make changes to this bug.