So everything, including the documents themselves is stored in Postgres?




-----Original Message-----
From: Tom De Mulder [mailto:[email protected]]
Sent: Friday, February 20, 2009 12:10 PM
To: West, Jeff
Cc: [email protected]
Subject: Re: [Dspace-tech] Backup procedure

On Fri, 20 Feb 2009, West, Jeff wrote:

> I would also be interested in an answer to this question.  We currently
>run Fedora 10 Linux.  We haven't populated anything, because we want
>clear way to backup and restore in the event of a server crash.

Are you running PostgreSQL?

In which case the pg_dump command is all you need. Run it on a regular
schedule with a user with sufficient access privileges, eg.

  pg_dump --format t yourdspacedbname > databasedump.2009-02-20.sql

That gives you a DB dump you can just "slurp" back in in future and will
be enough in almost all cases.


Best,

--
Tom De Mulder <[email protected]> - Cambridge University Computing Service
+44 1223 3 31843 - New Museums Site, Pembroke Street, Cambridge CB2 3QH
-> 20/02/2009 : The Moon is Waning Crescent (38% of Full)


------------------------------------------------------------------------------
Open Source Business Conference (OSBC), March 24-25, 2009, San Francisco, CA
-OSBC tackles the biggest issue in open source: Open Sourcing the Enterprise
-Strategies to boost innovation and cut costs with open source participation
-Receive a $600 discount off the registration fee with the source code: SFAD
http://p.sf.net/sfu/XcvMzF8H
_______________________________________________
DSpace-tech mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/dspace-tech

Reply via email to