Hi Mika, If you compare
http://www.postgresql.org/docs/8.1/static/sql-altersequence.html with http://www.postgresql.org/docs/8.3/static/sql-altersequence.html You'll note that the "ALTER SEQUENCE [name] OWNED BY [table_name]..." syntax doesn't exist in Postgres 8.1.x I had a quick look at the pg_dump manpage and didn't see any obvious "maximise compatibility" options, so I think this one might need fixing by hand. It shouldn't be too hard to massage the SQL into something 8.1 will accept, but the different ALTER SEQUENCE syntax could be the first of many similar problems.... nothing some good sed/perl regexes won't fix ;) Cheers, Kim -- Kim Shepherd IRR Technical Specialist ITS Systems & Development The University of Waikato New Zealand DDI +64 7 838 4025 > -----Original Message----- > From: mikan.d.dspace listmail [mailto:[email protected]] > Sent: Thursday, 11 June 2009 11:38 p.m. > To: Dspace Tech > Subject: [Dspace-tech] Error importing database dump > > Im moving one of our DSpace insntances to a new server. Our old server > has Postgres 8.3 installed, the new one has 8.1.11. > When running db import created with pg_dump I get the following > errors. I also tried restoring with pg_restore, but that didnt help. > Could someone tell me whats the problem here? > > Thanks, > Mika > > psql:/tmp/neurop5.sql:412: ERROR: syntax error at or near "OWNED" at > character 46 > psql:/tmp/neurop5.sql:412: LINE 1: ALTER SEQUENCE > checksum_history_check_id_seq OWNED BY checks... > > ----------------------------------------------------------------------- > ------- > Crystal Reports - New Free Runtime and 30 Day Trial > Check out the new simplified licensing option that enables unlimited > royalty-free distribution of the report engine for externally facing > server and web deployment. > http://p.sf.net/sfu/businessobjects > _______________________________________________ > DSpace-tech mailing list > [email protected] > https://lists.sourceforge.net/lists/listinfo/dspace-tech ------------------------------------------------------------------------------ Crystal Reports - New Free Runtime and 30 Day Trial Check out the new simplified licensing option that enables unlimited royalty-free distribution of the report engine for externally facing server and web deployment. http://p.sf.net/sfu/businessobjects _______________________________________________ DSpace-tech mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/dspace-tech
