---------- Forwarded message ----------
From: rudra chandana <[EMAIL PROTECTED]>
Date: Feb 21, 2007 6:32 PM
Subject: upgrading dspace from 1.3.2 to 1.4
To: [EMAIL PROTECTED]
I ve installed a new dspace 1.4,and its successfully running. already i ve
databse stored on dspace1.3.2 on a different machine. I need to copy the
database to the new server (using pg_dumpall and psql ) ive got the database
into dspace1.4 server. But while executing the psql -f command its showing
errors.
I ve also used the upgrade command i.e psql -f
database_schema_13-14.sql dspace -h localhost
this also is not working.Its showing th flg.
errors.
******************
psql:database_schema_13-14.sql:50: ERROR:
relation "group2group_seq" already exists
psql:database_schema_13-14.sql:51: ERROR: relation "group2groupcache_seq"
already exists
psql:database_schema_13-14.sql:61: NOTICE: CREATE TABLE / PRIMARY KEY will
create implicit index "group2group_pkey" for table "group2group"
psql:database_schema_13-14.sql:61: ERROR: permission denied for relation
epersongroup
psql:database_schema_13-14.sql:77: NOTICE: CREATE TABLE / PRIMARY KEY will
create implicit index "group2groupcache_pkey" for table "group2groupcache"
psql:database_schema_13-14.sql:77: ERROR: permission denied for relation
epersongroup
psql:database_schema_13-14.sql:83: ERROR: relation
"metadataschemaregistry_seq" already exists
psql:database_schema_13-14.sql:84: ERROR: relation
"metadatafieldregistry_seq" already exists
psql:database_schema_13-14.sql:85: ERROR: relation "metadatavalue_seq"
already exists
psql:database_schema_13-14.sql:93: NOTICE: CREATE TABLE / PRIMARY KEY will
create implicit index "metadataschemaregistry_pkey" for table
"metadataschemaregistry"
psql:database_schema_13-14.sql:93: NOTICE: CREATE TABLE / UNIQUE will
create implicit index "metadataschemaregistry_namespace_key" for table
"metadataschemaregistry"
psql:database_schema_13-14.sql:93: ERROR: relation "metadataschemaregistry"
already exists
psql:database_schema_13-14.sql:103: NOTICE: CREATE TABLE / PRIMARY KEY will
create implicit index "metadatafieldregistry_pkey" for table
"metadatafieldregistry"
psql:database_schema_13-14.sql:103: ERROR: relation "metadatafieldregistry"
already exists
psql:database_schema_13-14.sql:114: NOTICE: CREATE TABLE / PRIMARY KEY will
create implicit index "metadatavalue_pkey" for table "metadatavalue"
psql:database_schema_13-14.sql:114: ERROR: permission denied for relation
item
psql:database_schema_13-14.sql:117: ERROR: relation "metadatavalue" does
not exist
psql:database_schema_13-14.sql:118: ERROR: relation "metadatavalue" does
not exist
psql:database_schema_13-14.sql:119: ERROR: relation
"metadatafield_schema_idx" already exists
psql:database_schema_13-14.sql:122: ERROR: duplicate key violates unique
constraint "metadataschemaregistry_pkey"
psql:database_schema_13-14.sql:128: ERROR: permission denied for relation
dctyperegistry
psql:database_schema_13-14.sql:132: ERROR: relation "metadatavalue" does
not exist
psql:database_schema_13-14.sql:134: ERROR: must be owner of relation
dcvalue
psql:database_schema_13-14.sql:141: ERROR: relation "metadatavalue" does
not exist
setval
--------
(1 row)
psql:database_schema_13-14.sql:144: ERROR: relation "metadatavalue" does
not exist
setval
--------
1
(1 row)
psql:database_schema_13-14.sql:147: ERROR: must be owner of relation
dctyperegistry
psql:database_schema_13-14.sql:153: ERROR: must be owner of relation
bitstream
psql:database_schema_13-14.sql:154: ERROR: column "size_bytes" of relation
"bitstream" does not exist
psql:database_schema_13-14.sql:155: ERROR: must be owner of relation
bitstream
psql:database_schema_13-14.sql:167: NOTICE: CREATE TABLE / PRIMARY KEY will
create implicit index "checksum_results_pkey" for table "checksum_results"
psql:database_schema_13-14.sql:167: ERROR: relation "checksum_results"
already exists
psql:database_schema_13-14.sql:187: NOTICE: CREATE TABLE / PRIMARY KEY will
create implicit index "most_recent_checksum_pkey" for table
"most_recent_checksum"
psql:database_schema_13-14.sql:187: ERROR: permission denied for relation
bitstream
psql:database_schema_13-14.sql:202: NOTICE: CREATE TABLE will create
implicit sequence "checksum_history_check_id_seq" for "serial" column
"checksum_history.check_id"
psql:database_schema_13-14.sql:202: NOTICE: CREATE TABLE / PRIMARY KEY will
create implicit index "checksum_history_pkey" for table "checksum_history"
psql:database_schema_13-14.sql:202: ERROR: relation
"checksum_history_check_id_seq" already exists
psql:database_schema_13-14.sql:212: ERROR: duplicate key violates unique
constraint "checksum_results_pkey"
psql:database_schema_13-14.sql:219: ERROR: duplicate key violates unique
constraint "checksum_results_pkey"
psql:database_schema_13-14.sql:226: ERROR: duplicate key violates unique
constraint "checksum_results_pkey"
psql:database_schema_13-14.sql:233: ERROR: duplicate key violates unique
constraint "checksum_results_pkey"
psql:database_schema_13-14.sql:240: ERROR: duplicate key violates unique
constraint "checksum_results_pkey"
psql:database_schema_13-14.sql:247: ERROR: duplicate key violates unique
constraint "checksum_results_pkey"
psql:database_schema_13-14.sql:254: ERROR: duplicate key violates unique
constraint "checksum_results_pkey"
psql:database_schema_13-14.sql:260: ERROR: duplicate key violates unique
constraint "checksum_results_pkey"
psql:database_schema_13-14.sql:266: ERROR: duplicate key violates unique
constraint "checksum_results_pkey"
psql:database_schema_13-14.sql:293: ERROR: relation "most_recent_checksum"
does not exist
psql:database_schema_13-14.sql:304: ERROR: relation "most_recent_checksum"
does not exist
psql:database_schema_13-14.sql:324: ERROR: relation "most_recent_checksum"
does not exist
UPDATE 0
psql:database_schema_13-14.sql:338: ERROR: must be owner of relation
community
psql:database_schema_13-14.sql:344: ERROR: relation "itemsbysubject_seq"
already exists
psql:database_schema_13-14.sql:355: NOTICE: CREATE TABLE / PRIMARY KEY will
create implicit index "itemsbysubject_pkey" for table "itemsbysubject"
psql:database_schema_13-14.sql:355: ERROR: permission denied for relation
item
psql:database_schema_13-14.sql:358: ERROR: relation "itemsbysubject" does
not exist
psql:database_schema_13-14.sql:367: ERROR: relation "itemsbysubject" does
not exist
psql:database_schema_13-14.sql:376: ERROR: relation "itemsbysubject" does
not exist
******************
What should i do? Kindly advise.
-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys-and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
DSpace-tech mailing list
DSpace-tech@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/dspace-tech