> We (you, me, everyone) are currently presented with a problem when > upgrading > our installed version of PostgreSQL when upgrading to a major release > version (i.e. 8.2 to 8.3, or 8.3 to 8.4) Is it not possible to have > PostgreSQL "upgrade" the actual database cluster upon installing a new > major > version? I don't mean as a step during the actual upgrade. I'm > suggesting > that, if the database cluster has some sort of attribute which Postgres > could read which would identify the latest version it was running against, > then a tool (let's call it pg_upgrade) runs against that cluster to make > it > work against the newly installed version. Debian has an add-on named pg_upgradecluster which transforms an existing cluster into a new one transferring databases via dump/restore. This works nicely as long as the databases are not "too large" with respect to the hardware specs they are running on. Karsten -- Psssst! Schon vom neuen GMX MultiMessenger gehört? Der kann`s mit allen: http://www.gmx.net/de/go/multimessenger01 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
