Just Launched: You can now import projects and releases from Google Code onto SourceForge
We are excited to release new functionality to enable a 1-click import from Google Code onto the Allura platform on SourceForge. You can import tickets, wikis, source, releases, and more with a few simple steps. Read More
From: Tansley, Robert <robert.tansley@hp...> - 2004-11-19 21:20:10
Thanks for raising a question we should have a much more concrete answer
for, given that one of the main aims of DSpace is as a tool for
I've put some initial thoughts up on the DSpace Wiki:
This may be a bit more information than you were expecting! However,
it's an involved and important issue. Hopefully those of you with
experience running a DSpace (and perhaps even having done a backup &
restore) can add their experiences to that page.
Robert Tansley / Digital Media Systems Programme / HP Labs
> -----Original Message-----
> From: dspace-tech-admin@...=20
> [mailto:dspace-tech-admin@...] On Behalf Of=20
> Jeffrey Trimble
> Sent: 18 November 2004 14:38
> To: dspace-tech@...
> Subject: [Dspace-tech] Backup and restore
> I should like to ask if anyone has had to perform a backup=20
> and restore of=20
> their Dspace
> I have backuped up the following data, with all files closed=20
> in postgres=20
> and tomcat is closed.
> I also have backed up some configuration files from my /etc=20
> folder for=20
> automatic initialization.
> Any caveats? Do I need to complete a re-install of any software?
> All comments greatly appreciated.
From: Mark H. Wood <mwood@IUPUI.Edu> - 2004-11-22 13:59:40
-----BEGIN PGP SIGNED MESSAGE-----
I really wouldn't recommend relying solely on option 1 (filesystem
backup). There's no reason to believe that you would get a usable backup
of PostgreSQL's data store if the database monitor is running, since it
makes its own decisions about locking and cache sweeping and doesn't share
them with the filesystem code. If you stop the JSP host (Tomcat or
whatever) and the DBMS then it should work.
I'm currently taking a somewhat Q&D approach: every night, along with the
DBMS vacuum run, the entire database is dumped to a file. This is timed
so that it should be completed well before the scheduled filesystem
backup. I've requested that the DBMS directories *not* be backed up,
since that's just wasted motion with the monitor running, but the backup
should have a usable snapshot of the database in the dump file.
It would be nice if we could just have the backup product take care of the
database itself, but HP Data Protector has no idea how to talk to
PostgreSQL. Maybe someday I'll find (a) spec.s for interfacing DP agents,
and (b) enough free time to write an agent for PG.
Mark H. Wood, Lead System Programmer mwood@...
Open-source executable: $0.00. Source: $0.00 Control: priceless!
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.3 (GNU/Linux)
Comment: pgpenvelope 2.10.2 - http://pgpenvelope.sourceforge.net/
-----END PGP SIGNATURE-----