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