Dear Sir,
I want to move data from Dsapce 1.4.2(postgres 7.4.19) old server to
DSpace 1.7 (postgres 8.4.4) new server . Please let me know the the
following steps are right?
Please Reply.
With regards
Indu Bhushan, RRCAT Library, Indore
1. [dspace@library-1 dspace]$ mvn -Pxpdf-mediafilter-support package
[INFO] BUILD SUCCESS
2. Backup of (postgres 7.4.19) old server and restore in (postgres 8.4.4)
new server .
Su postgres
[postgres@library data]$ pg_dump dspace > dspace.sql BACKUP from
Postgres 7.4.19 and Dspace 1.4.2
[postgres@localhost root]$ psql -f dspace.sql dspace RESTORE in
Postgres 8.4.4 and Dspace 1.7
( following steps shown error when i tried with dsapce 1.6.2, error
attached)
psql -U dspace -f
/dspace1.7/dspace/etc/postgres/database_schema_14-15.sql dspace
psql -U dspace -f
/dspace1.7/dspace/etc/postgres/database_schema_15-16.sql dspace
psql -U dspace -f
/dspace1.7/dspace/etc/postgres/database_schema_16_17.sql dspace
3. [dspace@library-1 dspace]$ cd
[dspace-source]/dspace/target/dspace-[version]-build.dir
[dspace@library-1 dspace]$ ant fresh_install
[dspace@library-1 dspace]$ /bin/dspace registry-loader -bitstream
[dspace]/etc/upgrades/14-15/new-bitstream-formats.xml
[dspace@library-1 dspace]$ /bin/dspace registry-loader -bitstream
[dspace]/etc/upgrades/15-16/new-bitstream-formats.xml
[dspace@library-1 dspace]$ /bin/dspace registry-loader -bitstream
[dspace]/etc/upgrades/16-17/new-bitstream-formats.xml
4. Copy assestore dirctory from Dsapce 1.4.2 old server to DSpace 1.7 new
server
5 cp -r [dspace]/webapps/* [tomcat]/webapps and starting tomcat
/etc/init.d/tomcat
start
6. I think *no need to create admin* as it will come with backup files
[dspace]/bin/dspace create-administrator
====================================================
Error of database_schema update when i tried with dsapce 1.6.2, error
ERROR: column "admin" of relation "community" already exists
STATEMENT: ALTER TABLE community ADD admin INTEGER REFERENCES epersongroup
( eperson_group_id );
psql:/diglib/dspace/dspace/etc/postgres/database_schema_15-16.sql:49:
ERROR: column "admin" of relation "community" already exists
ERROR: relation "community_admin_fk_idx" already exists
STATEMENT: CREATE INDEX community_admin_fk_idx ON Community(admin);
psql:/diglib/dspace/dspace/etc/postgres/database_schema_15-16.sql:50:
ERROR: relation "community_admin_fk_idx" already exists
ERROR: column "authority" of relation "metadatavalue" already exists
STATEMENT: ALTER TABLE MetadataValue ADD authority VARCHAR(100);
psql:/diglib/dspace/dspace/etc/postgres/database_schema_15-16.sql:55:
ERROR: column "authority" of relation "metadatavalue" already exists
ERROR: column "confidence" of relation "metadatavalue" already exists
STATEMENT: ALTER TABLE MetadataValue ADD confidence INTEGER DEFAULT -1;
psql:/diglib/dspace/dspace/etc/postgres/database_schema_15-16.sql:56:
ERROR: column "confidence" of relation "metadatavalue" already exists
ERROR: relation "harvested_collection_seq" already exists
STATEMENT: CREATE SEQUENCE harvested_collection_seq;
psql:/diglib/dspace/dspace/etc/postgres/database_schema_15-16.sql:61:
ERROR: relation "harvested_collection_seq" already exists
ERROR: relation "harvested_item_seq" already exists
STATEMENT: CREATE SEQUENCE harvested_item_seq;
psql:/diglib/dspace/dspace/etc/postgres/database_schema_15-16.sql:62:
ERROR: relation "harvested_item_seq" already exists
ERROR: relation "harvested_collection" already exists
STATEMENT: CREATE TABLE harvested_collection
(
collection_id INTEGER REFERENCES collection(collection_id) ON
DELETE CASCADE,
harvest_type INTEGER,
oai_source VARCHAR,
oai_set_id VARCHAR,
harvest_message VARCHAR,
metadata_config_id VARCHAR,
harvest_status INTEGER,
harvest_start_time TIMESTAMP WITH TIME ZONE,
last_harvested TIMESTAMP WITH TIME ZONE,
id INTEGER PRIMARY KEY
);
psql:/diglib/dspace/dspace/etc/postgres/database_schema_15-16.sql:82:
ERROR: relation "harvested_collection" already exists
ERROR: relation "harvested_collection_fk_idx" already exists
STATEMENT: CREATE INDEX harvested_collection_fk_idx ON
harvested_collection(collection_id);
psql:/diglib/dspace/dspace/etc/postgres/database_schema_15-16.sql:84:
ERROR: relation "harvested_collection_fk_idx" already exists
ERROR: relation "harvested_item" already exists
STATEMENT: CREATE TABLE harvested_item
(
item_id INTEGER REFERENCES item(item_id) ON DELETE CASCADE,
last_harvested TIMESTAMP WITH TIME ZONE,
oai_id VARCHAR,
id INTEGER PRIMARY KEY
);
psql:/diglib/dspace/dspace/etc/postgres/database_schema_15-16.sql:93:
ERROR: relation "harvested_item" already exists
ERROR: relation "harvested_item_fk_idx" already exists
STATEMENT: CREATE INDEX harvested_item_fk_idx ON harvested_item(item_id);
psql:/diglib/dspace/dspace/etc/postgres/database_schema_15-16.sql:95:
ERROR: relation "harvested_item_fk_idx" already exists
UPDATE 3
ERROR: constraint "community2collection_collection_id_fkey" of relation
"community2collection" does not exist
STATEMENT: ALTER TABLE community2collection DROP CONSTRAINT
community2collection_collection_id_fkey;
psql:/diglib/dspace/dspace/etc/postgres/database_schema_15-16.sql:105:
ERROR: constraint "community2collection_collection_id_fkey" of relation
"community2collection" does not exist
ERROR: constraint "comm2coll_collection_fk" for relation
"community2collection" already exists
STATEMENT: ALTER TABLE community2collection ADD CONSTRAINT
comm2coll_collection_fk FOREIGN KEY (collection_id) REFERENCES collection
DEFERRABLE;
psql:/diglib/dspace/dspace/etc/postgres/database_schema_15-16.sql:106:
ERROR: constraint "comm2coll_collection_fk" for relation
"community2collection" already exists
ERROR: constraint "community2community_child_comm_id_fkey" of relation
"community2community" does not exist
STATEMENT: ALTER TABLE community2community DROP CONSTRAINT
community2community_child_comm_id_fkey;
psql:/diglib/dspace/dspace/etc/postgres/database_schema_15-16.sql:108:
ERROR: constraint "community2community_child_comm_id_fkey" of relation
"community2community" does not exist
ERROR: constraint "com2com_child_fk" for relation "community2community"
already exists
STATEMENT: ALTER TABLE community2community ADD CONSTRAINT com2com_child_fk
FOREIGN KEY (child_comm_id) REFERENCES community DEFERRABLE;
psql:/diglib/dspace/dspace/etc/postgres/database_schema_15-16.sql:109:
ERROR: constraint "com2com_child_fk" for relation "community2community"
already exists
ERROR: constraint "collection2item_item_id_fkey" of relation
"collection2item" does not exist
STATEMENT: ALTER TABLE collection2item DROP CONSTRAINT
collection2item_item_id_fkey;
psql:/diglib/dspace/dspace/etc/postgres/database_schema_15-16.sql:111:
ERROR: constraint "collection2item_item_id_fkey" of relation
"collection2item" does not exist
ERROR: constraint "coll2item_item_fk" for relation "collection2item"
already exists
STATEMENT: ALTER TABLE collection2item ADD CONSTRAINT coll2item_item_fk
FOREIGN KEY (item_id) REFERENCES item DEFERRABLE;
psql:/diglib/dspace/dspace/etc/postgres/database_schema_15-16.sql:112:
ERROR: constraint "coll2item_item_fk" for relation "collection2item"
already exists
UPDATE 0
UPDATE 0
=========================================================================================
[root@localhost ~]# su dspace
[dspace@localhost root]$ /diglib/tomcat/bin/startup.sh
Using CATALINA_BASE: /diglib/tomcat
Using CATALINA_HOME: /diglib/tomcat
Using CATALINA_TMPDIR: /diglib/tomcat/temp
Using JRE_HOME: /usr/local/jdk
Using CLASSPATH: /diglib/tomcat/bin/bootstrap.jar
[dspace@localhost root]$ ERROR: relation "bi_item" does not exist at
character 23
STATEMENT: SELECT bi_item.* FROM bi_item, (SELECT communities2item.item_id
FROM communities2item WHERE communities2item.community_id=$1 ) mappings
WHERE bi_item.item_id=mappings.item_id ORDER BY sort_3 DESC LIMIT $2
ERROR: relation "bi_item" does not exist at character 23
STATEMENT: SELECT bi_item.* FROM bi_item, (SELECT collection2item.item_id
FROM collection2item WHERE collection2item.collection_id=$1 ) mappings
WHERE bi_item.item_id=mappings.item_id ORDER BY sort_3 DESC LIMIT $2
ERROR: relation "bi_item" does not exist at character 23
STATEMENT: SELECT bi_item.* FROM bi_item, (SELECT collection2item.item_id
FROM collection2item WHERE collection2item.collection_id=$1 ) mappings
WHERE bi_item.item_id=mappings.item_id ORDER BY sort_3 DESC LIMIT $2
ERROR: relation "bi_item" does not exist at character 30
STATEMENT: SELECT COUNT(*) AS num FROM bi_item
ERROR: relation "bi_item" does not exist at character 23
STATEMENT: SELECT bi_item.* FROM bi_item, (SELECT collection2item.item_id
FROM collection2item WHERE collection2item.collection_id=$1 ) mappings
WHERE bi_item.item_id=mappings.item_id ORDER BY sort_3 DESC LIMIT $2
ERROR: relation "bi_item" does not exist at character 23
STATEMENT: SELECT bi_item.* FROM bi_item, (SELECT collection2item.item_id
FROM collection2item WHERE collection2item.collection_id=$1 ) mappings
WHERE bi_item.item_id=mappings.item_id ORDER BY sort_3 DESC LIMIT $2
ERROR: relation "bi_item" does not exist at character 23
STATEMENT: SELECT bi_item.* FROM bi_item, (SELECT collection2item.item_id
FROM collection2item WHERE collection2item.collection_id=$1 ) mappings
WHERE bi_item.item_id=mappings.item_id ORDER BY sort_3 DESC LIMIT $2
ERROR: relation "bi_item" does not exist at character 23
STATEMENT: SELECT bi_item.* FROM bi_item, (SELECT collection2item.item_id
FROM collection2item WHERE collection2item.collection_id=$1 ) mappings
WHERE bi_item.item_id=mappings.item_id ORDER BY sort_3 DESC LIMIT $2
ERROR: relation "bi_item" does not exist at character 23
STATEMENT: SELECT bi_item.* FROM bi_item, (SELECT collection2item.item_id
FROM collection2item WHERE collection2item.collection_id=$1 ) mappings
WHERE bi_item.item_id=mappings.item_id ORDER BY sort_3 DESC LIMIT
------------------------------------------------------------------------------
The modern datacenter depends on network connectivity to access resources
and provide services. The best practices for maximizing a physical server's
connectivity to a physical network are well understood - see how these
rules translate into the virtual world?
http://p.sf.net/sfu/oracle-sfdevnlfb
_______________________________________________
Dspace-general mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/dspace-general
