Red Hat Bugzilla – Bug 166916
upgrading postgresql does not warn about incompatability with older databases
Last modified: 2007-04-18 13:30:55 EDT
Description of problem, bug, incorrect information, or enhancement request:
When upgrading Fedora, if PostgreSQL is upgraded to a new major release (as with
FC3 to FC4), the user should be warned that old databases wouldn't be accessible
anymore. For PostgreSQL 7.x -> 8.0 upgrade procedure see:
Version of release notes this bug refers to:
Fedora Core 4 final release
Thank you for the report. Does Postgres break the database format in every major
release?. At any case this is something the installer should potentially warn
about if not taking care of the migration process required itself or through the
postgres package.If this is not feasible we can look into documenting a warning
in the release notes.
Reassigning it to component Anaconda and corresponding maintainer
(In reply to comment #1)
> Thank you for the report. Does Postgres break the database format in every
> major release?.
Presently yes, at every first or second number change (eg. 7.2.x -> 7.3.y or
7.4.x -> 8.0.y).
It's impossible for the installer to know and be able to warn about every
incompatibility in every package.
In general, packages should handle this sanely for themselves. Traditionally,
postgresql has only been handled by a release notes entry :/
Yeah, this is a problem the upstream project has struggled with and not really
found any satisfactory answer to. We tried auto-upgrade support in the RPMs for
awhile, but that didn't work decently either, so we eventually gave it up.
Basically this is something that has to be mentioned in the release notes every
time we update to a new major Postgres release.
(Hmm, do we have a "release notes" component I could reassign this to? I'm not
seeing one in the menu ...)
Yeah, we do, different product. You have to reassign and do an extra step,
which is what I'm about to do when I commit this change:
1. Pick product, Fedora Documentation
2. Commit change
3. Next page lets you pick new component within the new product
4. Choose release-notes component and commit
All is good from there, should be reassigned now.
You can also always add firstname.lastname@example.org in the Cc: if you want us to
note a bug without having to reassign it.
Maybe I missed something, this should fix it.
This bug has been fixed for the FC5 release notes
This same topic was addressed (and now resolved) in bug #182705.
This is fixed in the Wiki and shall be the source for the FC5 final release notes.