Hi,
We are planning to migrate from 1.3.2 to 1.4.1. In the operational
DSpace1.3.2 (http://drs.nio.org) there are lots of customisations. So we
don't want to migrate directly. But to check the migration in a test server
first.
I have installed DSpace1.4.1 in test server. Now I want to use database &
assetstore of DSpace1.3.2 in DSpace.1.4.1. I have got the "dspace.sql" from
DSpace1.3.2 using "pg_dump dspace > dspace.sql". I uploaded "assetstore" in
DSpace1.4.1. But I am wandering, "how to restore dspace.sql of DSpace1.3.2
in DSpace1.4.1 to reflect the database schema of 1.4.1.
I tried following but unsuccessful:
1. Drop the database of 1.4.1
2. Creat new database
3. psql dspace < dspace.sql (1.3.2)
But it is showing problem as follows:
SET
SET
ERROR: permission denied to set session authorization
REVOKE
ERROR: permission denied for schema public
SET
SET
ERROR: function "getnextid" already exists with same argument types
ERROR: relation "bitstreamformatregistry_seq" already exists
ERROR: relation "fileextension_seq" already exists
...
....
....
psql:dspace.sql:112401: ERROR: permission denied to set session
authorization
psql:dspace.sql:112408: ERROR: must be owner of schema public
Please inform me the process of using database of DSpace1.3.2 in freshly
installed DSpace1.4.1
Thanking you
With regards
Satya
-------------------------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems? Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >> http://get.splunk.com/
_______________________________________________
DSpace-tech mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/dspace-tech
