> 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 ultimate all-in-one performance toolkit: Intel(R) Parallel Studio XE:
Pinpoint memory and threading errors before they happen.
Find and fix more than 250 security defects in the development cycle.
Locate bottlenecks in serial and parallel code that limit performance.
http://p.sf.net/sfu/intel-dev2devfeb
_______________________________________________
DSpace-tech mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/dspace-tech
