Red Hat Bugzilla – Bug 160463
postgresql installed by FC4 needs a different data format than FC3
Last modified: 2013-07-02 23:06:07 EDT
From Bugzilla Helper:
User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-GB; rv:1.7.8) Gecko/20050524 Fedora/1.0.4-4 Firefox/1.0.4
Description of problem:
FC3 had postgresql 7.4 but FC4 has 8.0.3. The latter will not start and reports that the data format needs to be updated. However, to update the data according to the instructions by postgresql.org you need to have a running postgresql server. Catch 22.
Version-Release number of selected component (if applicable):
Steps to Reproduce:
1. have postgresql in FC3
2. install FC4
3. try starting postgresql
You have to dump and restore the old database. This has always been true of
every major Postgres version upgrade, and 7.4 -> 8.0 is no different.
Yes, of course, but if you install FC4 (postgres 8.0) over FC3 (postgres 7.4),
you only realize you had to dump your database after you already installed FC4.
And once you installed FC4, you can't dump your database because postgres 8.0