[WBEL-users] PostgreSQL 8.0 ?

[Aly Dharshi]

I guess that I was thinking in terms of just an srpm->rpm->install/upgrade, you 
must ofcourse do the database side tasks as mentioned by Lamar, otherwise bad 
things may occur.

Lamar Owen wrote:

> 
> No, it will not.
> 
> You must dump your data, wipe the PGDATA directory tree, do the rpm upgrade, 
> start it with service postgresql start (NOT service rhdb start), let it do 
> the initdb, then restore your dump.  It may or may not restore cleanly, 
> depending on your customizations.
> 
> There may be other issues. 
> 
> But I seriously question the need to use non-stable software in release 
> candidate stage due to a deadline.  You may get egg in your face due to that; 
> IOW, what feature of 8.0 do you need that you absolutely cannot wait for?
> 
> BTW, I say all this with more than a little experience.  Up until last month I 
> was the RPM maintainer for the PostgreSQL Global Development Group (and had 
> been for five years), so this is an issue over which I have agonized time and 
> time again.  My lack of extra time, particularly in the 8.0 cycle, led me to 
> pass the torch to Devrim Gunduz in Turkey last month.
> 
> PostgreSQL major version upgrades are nearly as hard as kernel major version 
> upgrades (like 2.4.x to 2.6.x), so tread carefully.

-- 
Aly Dharshi
aly.dharshi@telus.net

	 "A good speech is like a good dress
	  that's short enough to be interesting
	  and long enough to cover the subject"