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: http://www.postgresql.org/docs/8.0/interactive/install-upgrading.html 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 relnotes 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 http://fedoraproject.org/wiki/Docs/Beats/DatabaseServers
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.