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): How reproducible: Always Steps to Reproduce: 1. have postgresql in FC3 2. install FC4 3. try starting postgresql Additional info:
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 won't start...