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
