Hello Steve,
All the pg_dump contains is the relational db tables, not the
contents of the bitreams, which reside in the Assetstore, so its
always a "fraction of the total size of your repository contents) If
you compressed the pg_dump file (-Fc) then it is a gzip compressed
file) if you leave of the (-Fc) it will be a text based SQL dump file
that you can view.
Without another server to bring it up in, you can simply just create
another database copy in you currently running instance (as well you
can reconfigure dspace.cfg to point at this new copy for testing).
For instance if your initial dump command looked like this:
pg_dump -o -C -Fc dspace > /tmp/dspace-db.out
then as dspace user:
createdb dspace-copy
pg_restore -c -d dspace-copy /tmp/dspace-db.out
Note, you may initially see a bunch of error messages saying that the
restore is trying to alter the public schema. But I've found these
errors not to be a significant issue in our production environment.
-Mark
On Jan 23, 2007, at 12:27 AM, Steve Thomas wrote:
Hi.
I’ve just run pg_dump for the first time, and … I was gobsmacked to
find it took only a minute or so to run. This from a database size
of 23,000 items. I was expecting much longer.
Is this normal, or did something go wrong?
Looking at the file gives no clues, since it’s largely unreadable.
The output file size of +20MB suggests it worked, and pg_dump gave
no messages, which is probably a good sign.
Short of doing a restore (difficult without a spare server), is
there any way I can be sure that the dump worked?
Cheers!
Steve
Stephen Thomas,
Senior Systems Analyst,
University of Adelaide Library
UNIVERSITY OF ADELAIDE SA 5005 AUSTRALIA
Phone: +61 8 830 35190
Fax: +61 8 830 34369
Email: [EMAIL PROTECTED]
URL: http://www.adelaide.edu.au/directory/stephen.thomas
CRICOS Provider Number 00123M
-----------------------------------------------------------
This email message is intended only for the addressee(s) and
contains information that may be confidential and/or copyright. If
you are not the intended recipient please notify the sender by
reply email and immediately delete this email. Use, disclosure or
reproduction of this email by anyone other than the intended
recipient(s) is strictly prohibited. No representation is made that
this email or any attachments are free of viruses. Virus scanning
is recommended and is the responsibility of the recipient.
----------------------------------------------------------------------
---
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
[email protected]
https://lists.sourceforge.net/lists/listinfo/dspace-tech
Mark R. Diggory
~~~~~~~~~~~~~
DSpace Systems Manager
MIT Libraries, Systems and Technology Services
Massachusetts Institute of Technology
-------------------------------------------------------------------------
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
[email protected]
https://lists.sourceforge.net/lists/listinfo/dspace-tech
