On Tue, Jan 18, 2005 at 04:36:21PM -0800, Ron Mayer wrote: > Subject says it all. You can check if an upgrade requires an initdb by comparing catalog versions between your current version and the new version. To find out your current catalog version, run pg_controldata and look for the following line: Catalog version number: 200411041 In the new version's source code look for the following line in src/include/catalog/catversion.h: #define CATALOG_VERSION_NO 200411041 If the catalog versions match then you shouldn't need to do an initdb; if they're different then you will. Making a full dump anyway before upgrading might be prudent just in case, however. The most recent catalog version change appears to have been committed on 2004/11/05. I think 8.0.0beta4 was the next version after that, so if you're running 8.0.0beta4 or later then I wouldn't expect an initdb to be required to move to 8.0.0. But don't hold me to that.... -- Michael Fuhr http://www.fuhr.org/~mfuhr/ ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
