[CentOS] RPM conflicts - help!

[Lamar Owen]

On Thursday 29 December 2005 07:01, Johnny Hughes wrote:
> > Is this PG 8.1 ever going to be part of the official 4.x release, or is
> > this something that's done separately by you instead of coming from

> No, it will never be in base / updates, it will be in centosplus (after
> we move it out of testing).

You need to warn people about updating with centosplus enabled, otherwise if 
they use centosplus (for perhaps the unsupported kernels or PHP5) and they 
have a running PostgreSQL instance, they will get a nasty surprise.

To the OP, a major PostgreSQL version jump/upgrade is virtually impossible to 
automate within the constraints of the RPM mechanism (and yum/up2date do not 
change the underlying mechanism, except perhaps the order in which triggers 
fire and scriptlets execute, but I've not tested that).  You need to know to 
do a full backup/dump and wipe the database dir before the upgrade, then do 
your restore.  Database upgrades are not easy; PostgreSQL, because of the way 
and depth in which it can be extended can be more difficult than most, but 
that's due to its power.
-- 
Lamar Owen
Director of Information Technology
Pisgah Astronomical Research Institute
1 PARI Drive
Rosman, NC  28772
(828)862-5554
www.pari.edu