Hi everyone A word of warning from a relative novice ;)
I managed to upgrade PostgreSQL to 8.2.4 on CentOS 5.5 and the DSpace 1.7.0 index-init script ran fine :) Unfortunately the PostgreSQL upgrade broke a lot of essential system services, so I had to restore the entire build on the test server from a backup made before the upgrade :(( I'll try again when I can find some more time... Best wishes Clive On Fri, Dec 31, 2010 at 6:50 PM, Clive Gould <[email protected]> wrote: > Hi Keith > > I've just checked and CentOS 5 uses postgresql 8.1.2 > > This means I need to upgrade PostgreSQL before going any further. > > Thanks very much > > Clive > > > On Fri, Dec 31, 2010 at 5:48 PM, Keith Gilbertson > <[email protected]> wrote: >> >> On Dec 31, 2010, at 7:34 AM, Clive Gould wrote: >> >>> Hi everyone >>> >>> I've just tried to upgrade DSpace on our test server (CentOS Linux) >>> from version 1.6.2 to 1.7.0 >>> >>> I have got to the very end of the upgrade procedure only to be faced >>> by the following error message when I try to run the index script: >>> >>> [dsp...@standbyvle dspace-1.7.0-build.dir]$ psql -U dspace -f >>> /home/dspace/dspace-1.7.0-src-release/dspace/etc/postgres/database_schema_16-17.sql >>> dspace >>> DROP SEQUENCE >>> [dsp...@standbyvle dspace-1.7.0-build.dir]$ /home/dspace/bin/dspace >>> index-init >>> Started: 1293794521880 >>> Ended: 1293794523440 >>> Elapsed time: 1 secs (1560 msecs) >>> Exception: org.postgresql.util.PSQLException: ERROR: syntax error at >>> or near "RETURNING" >> >> >> Clive, >> >> DSpace 1.7 requires a PostgreSQL version of 8.2 or higher. This looks like >> a message that you might receive when you use an older version. >> >> --keith >> >> > ------------------------------------------------------------------------------ Learn how Oracle Real Application Clusters (RAC) One Node allows customers to consolidate database storage, standardize their database environment, and, should the need arise, upgrade to a full multi-node Oracle RAC database without downtime or disruption http://p.sf.net/sfu/oracle-sfdevnl _______________________________________________ DSpace-tech mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/dspace-tech
