Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: copying Ivan's tweaks to update-sequences to the other section where it is mentioned

...

Note
titleHighly Recommended to Update Database Sequences after a Large Restore

In some cases, when you restore a large amount of content to your DSpace, the internal database counts (called "sequences") may get out of sync with the Handles of the content you just restored. As a best practice, it is highly recommended to always re-run the "update-sequences.sql" script on your DSpace database after a larger scale restore. This database script can should be run while the system DSpace is online (i.e. no need to stopped (you may either stop Tomcat or PostgreSQL)just the DSpace webapps). PostgreSQL/Oracle must be running. The script can be found in the following locations for PostgreSQL and Oracle, respectively:
 [dspace]/etc/postgres/update-sequences.sql
 [dspace]/etc/oracle/update-sequences.sql

...