Summary: | Postgresql: pg-hier use flag requires initdb, you can't use an old data dir, just like a 7.4 -> 8.0 upgrade | ||
---|---|---|---|
Product: | Gentoo Linux | Reporter: | Russell Smith <mr-russ> |
Component: | [OLD] Server | Assignee: | PgSQL Bugs <pgsql-bugs> |
Status: | RESOLVED WONTFIX | ||
Severity: | normal | CC: | esigra |
Priority: | High | ||
Version: | unspecified | ||
Hardware: | All | ||
OS: | All | ||
URL: | http://gppl.moonbone.ru/ | ||
Whiteboard: | |||
Package list: | Runtime testing required: | --- |
Description
Russell Smith
2005-06-03 17:32:51 UTC
This comment written by Alvaro Herrera, <alvherre@dcc.uchile.cl>: One way to make the installation automatically detect the incompatibility between the two versions, is have the pg-hier patch modify the src/include/catalog/catversion.h file, to change the CATALOG_VERSION_NO #definition. This symbol is what is used to force initdb's across major versions of the mainline PostgreSQL. 7.4 ships with CATALOG_VERSION_NO 200310211, and all 7.4 releases are guaranteed to have the same definition; however I think it would be unwise to just increment the number by one, because "you never know." This would work: Index: catversion.h =================================================================== RCS file: /home/alvherre/cvs/pgsql/src/include/catalog/catversion.h,v retrieving revision 1.210 diff -u -r1.210 catversion.h --- catversion.h 21 Oct 2003 16:23:16 -0000 1.210 +++ catversion.h 4 Jun 2005 01:16:16 -0000 @@ -53,6 +53,6 @@ */ /* yyyymmddN */ -#define CATALOG_VERSION_NO 200310211 +#define CATALOG_VERSION_NO 200310210 #endif The pg-hier patch will be soon dropped with the new PostgreSQL packages we're preparing, as it's dead and abandoned upstream, and only compatible with older PostgreSQL versions. Thus, closing this! Best regards, CHTEKK. |