Hi, I've been running tests for upgrading our DSpace 1.4.2 installation to 1.6.x while remaining on PostgreSQL 7.4. For the upgrade steps to succeed I had to make a couple of changes to the database schema migration steps because PSQL 7.4 doesn't seem to support 1) changing a data type of an existing column 2) setting a default value when adding a new column.
Otherwise, it seems that the upgrading steps work as supposed also when upgrading from 1.4.2 directly to 1.6.x. I hope this helps someone. Best Regards, Asko 1) --- a/database_schema_14-15.sql 2010-03-02 18:41:16.000000000 +0000 +++ b/database_schema_14-15.sql 2010-04-15 07:42:39.000000000 +0000 @@ -65,7 +65,11 @@ -- Increase the mimetype field size to support larger types, such as the -- new Word 2007 mimetypes. ------------------------------------------------------------------------- -ALTER TABLE BitstreamFormatRegistry ALTER COLUMN mimetype TYPE VARCHAR(256); +ALTER TABLE BitstreamFormatRegistry ADD COLUMN mimetype_new VARCHAR(256); +UPDATE BitstreamFormatRegistry SET mimetype_new = mimetype; +ALTER TABLE BitstreamFormatRegistry RENAME mimetype TO mimetype_old; +ALTER TABLE BitstreamFormatRegistry RENAME mimetype_new TO mimetype; +ALTER TABLE BitstreamFormatRegistry DROP COLUMN mimetype_old; ------------------------------------------------------------------------- 2) --- a/database_schema_15-16.sql 2010-03-02 18:41:16.000000000 +0000 +++ b/database_schema_15-16.sql 2010-04-15 07:13:50.000000000 +0000 @@ -53,7 +53,10 @@ -- DS-236 schema changes for Authority Control of Metadata Values ------------------------------------------------------------------------- ALTER TABLE MetadataValue ADD authority VARCHAR(100); -ALTER TABLE MetadataValue ADD confidence INTEGER DEFAULT -1; +ALTER TABLE MetadataValue ADD confidence INTEGER; +UPDATE MetadataValue SET confidence = -1; +ALTER TABLE MetadataValue ALTER COLUMN confidence SET DEFAULT -1; +ALTER TABLE MetadataValue ALTER COLUMN confidence SET NOT NULL; ------------------------------------------------------------------ -- New tables /sequences for the harvester functionality (DS-289) ------------------------------------------------------------------------------ Download Intel® Parallel Studio Eval Try the new software tools for yourself. Speed compiling, find bugs proactively, and fine-tune applications for parallel performance. See why Intel Parallel Studio got high marks during beta. http://p.sf.net/sfu/intel-sw-dev _______________________________________________ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech
