Bug 160463

Summary:	postgresql installed by FC4 needs a different data format than FC3
Product:	[Fedora] Fedora	Reporter:	Flavio Cardone <fcardone>
Component:	postgresql	Assignee:	Tom Lane <tgl>
Status:	CLOSED NOTABUG	QA Contact:	David Lawrence <dkl>
Severity:	high	Docs Contact:
Priority:	medium
Version:	4	CC:	hhorak
Target Milestone:	---
Target Release:	---
Hardware:	i386
OS:	Linux
Whiteboard:
Fixed In Version:		Doc Type:	Bug Fix
Doc Text:		Story Points:	---
Clone Of:		Environment:
Last Closed:	2005-06-15 14:03:26 UTC	Type:	---
Regression:	---	Mount Type:	---
Documentation:	---	CRM:
Verified Versions:		Category:	---
oVirt Team:	---	RHEL 7.3 requirements from Atomic Host:
Cloudforms Team:	---	Target Upstream Version:
Embargoed:

Description Flavio Cardone 2005-06-15 10:11:28 UTC

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:

Comment 1 Tom Lane 2005-06-15 14:03:26 UTC

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.

Comment 2 Flavio Cardone 2005-06-16 08:48:34 UTC

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...