Sorry, this was probibly a bit short-sighted a response, I went and
tested it and the line numbers get reordered between submissions...
its difficult to merge.
What I might recommend is to get a list of all tables and sequences
effected in a group deletion and do the following.
1.) get the previous dump prior to the deletion, restore it to a new
db on a different machine
2.) dump only those tables and sequences to a sql dump file.
3.) restore those tables and sequences on a new copy of the existing
database
4.) test this, verify that it works and doesn't break anything.
5.) take your production system offline and back it up
6.) preform the task on your production system
7.) bring the production system online and test.
I believe the tables/sequences will be:
SEQUENCE epersongroup_seq;
SEQUENCE resourcepolicy_seq;
SEQUENCE epersongroup2eperson_seq;
SEQUENCE epersongroup2workspaceitem_seq;
SEQUENCE group2group_seq;
SEQUENCE group2groupcache_seq;
TABLE EPersonGroup
TABLE Group2Group
TABLE Group2GroupCache
TABLE ResourcePolicy
TABLE EPersonGroup2EPerson
TABLE epersongroup2workspaceitem
I'm 100% sure about this list, some may be important, some may not.
Hopefully you've not made changes to these tables since the
"incident"...
-Mark
On Nov 27, 2007, at 4:55 PM, Mark Diggory wrote:
If you have a sql dump backup from just prior to the incident you
could diff it against a new dump for comparison of what exactly is
different. Merging in the entries that were removed from
epersongroups and its various tables and then do a full restore of
the merged sql dump. But you'll want to be offline or set the
database to read-only during the process.
-Mark
On Nov 27, 2007, at 4:35 PM, George Kozak wrote:
Hi...
By accident, one of our Admins deleted a Group in
DSpace. Unfortunately, it is our largest group (the group of
students who can submit a thesis or dissertation and the professors
who can view those papers). Is there a way through PostGreSQL to
recover the group? I really don't want to restore the database from
backup because I will loose submissions and changes that have been
made.
***************************
George Kozak
Coordinator
Web Development and Management
Digital Media Group
501 Olin Library
Cornell University
607-255-8924
***************************
[EMAIL PROTECTED]
~~~~~~~~~~~~~
Mark R. Diggory - DSpace Systems Manager
MIT Libraries, Systems and Technology Services
Massachusetts Institute of Technology
----------------------------------------------------------------------
---
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2005.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
DSpace-tech mailing list
DSpace-tech@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/dspace-tech
-------------------------------------------------------------------------
SF.Net email is sponsored by: The Future of Linux Business White Paper
from Novell. From the desktop to the data center, Linux is going
mainstream. Let it simplify your IT future.
http://altfarm.mediaplex.com/ad/ck/8857-50307-18918-4
_______________________________________________
DSpace-tech mailing list
DSpace-tech@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/dspace-tech
