Hi
After restoring a postgresql database backup, I run as the documentation states:
psql -U dspace -f
/home/dspace/dspace-1.5.1-release/dspace/etc/update-sequences.sql
But I get some errors:
psql:/home/dspace/dspace-1.5.1-release/dspace/etc/update-sequences.sql:69:
ERROR: relation "dctyperegistry" does not exist
psql:/home/dspace/dspace-1.5.1-release/dspace/etc/update-sequences.sql:84:
ERROR: relation "history" does not exist
psql:/home/dspace/dspace-1.5.1-release/dspace/etc/update-sequences.sql:85:
ERROR: relation "historystate" does not exist
setval
--------
1202
(1 row)
psql:/home/dspace/dspace-1.5.1-release/dspace/etc/update-sequences.sql:87:
ERROR: relation "itemsbyauthor" does not exist
psql:/home/dspace/dspace-1.5.1-release/dspace/etc/update-sequences.sql:88:
ERROR: relation "itemsbytitle" does not exist
psql:/home/dspace/dspace-1.5.1-release/dspace/etc/update-sequences.sql:89:
ERROR: relation "itemsbydate" does not exist
psql:/home/dspace/dspace-1.5.1-release/dspace/etc/update-sequences.sql:90:
ERROR: relation "itemsbydateaccessioned" does not exists
Does it a bad thing or if the database was corrupted?
You can see the difference the first column is the dump after running
update-sequences.sql and the script index-update and the second one is
the dump of the backup
sdiff -s after-run-update.sql backup.sql
SELECT pg_catalog.setval('bitstreamformatregistry_seq', 35, t | SELECT
pg_catalog.setval('bitstreamformatregistry_seq', 38, t
SELECT pg_catalog.setval('community2community_seq', 2, true); | SELECT
pg_catalog.setval('community2community_seq', 10, true)
SELECT pg_catalog.setval('dcvalue_seq', 15331, true); | SELECT
pg_catalog.setval('dcvalue_seq', 4608, true);
SELECT pg_catalog.setval('epersongroup_seq', 135, true); | SELECT
pg_catalog.setval('epersongroup_seq', 139, true);
SELECT pg_catalog.setval('workspaceitem_seq', 472, true); | SELECT
pg_catalog.setval('workspaceitem_seq', 477, true);
Thanks in advance!
--
--
Sergio Belkin http://www.sergiobelkin.com
Watch More TV http://sebelk.blogspot.com
LPIC-2 Certified
------------------------------------------------------------------------------
Protect Your Site and Customers from Malware Attacks
Learn about various malware tactics and how to avoid them. Understand
malware threats, the impact they can have on your business, and how you
can protect your company and customers by using code signing.
http://p.sf.net/sfu/oracle-sfdevnl
_______________________________________________
DSpace-tech mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/dspace-tech
