Aim: DATA Migration from existing DSpace ver 5v5 server to DSpace 6v0 test server (Both are different machines) Operating system: Ubuntu 14.04
I have successfully installed DSpace 6v0 in my test machine. This is running Postgresql ver 9.5. Database backup of ver 5v5 has been taken using pg_dump command and trying to restore (This is also running Postgresql ver 9.5.) restore command that I am using is the following: dspace@angel:/dspace$ psql -U dspace dspace < /dspace_backup/db18May2017_1.sql towards the end it just stops. I tried google and none of the solutions are working for me and not sure what is the mistake I am doing. The error in the following text, I noticed is "ERROR: must be owner of extension plpgsql" Request someone to please help me in this regard, or show me a way to migrate data from ver 5.5 to 6.0. The output of the command is: dspace@angel:/dspace$ psql -U dspace dspace < /dspace_backup/db18May2017_1.sql Password for user dspace: SET SET SET SET SET SET SET CREATE EXTENSION ERROR: must be owner of extension plpgsql SET ERROR: function "getnextid" already exists with same argument types ALTER FUNCTION SET SET ERROR: relation "bitstream" already exists . . ALTER TABLE ERROR: relation "community" already exists -- You received this message because you are subscribed to the Google Groups "DSpace Technical Support" group. To unsubscribe from this group and stop receiving emails from it, send an email to dspace-tech+unsubscr...@googlegroups.com. To post to this group, send email to dspace-tech@googlegroups.com. Visit this group at https://groups.google.com/group/dspace-tech. For more options, visit https://groups.google.com/d/optout.
