The following does a decent postgres dump of dspace (we use it nightly to production as a backup and as means to copy/move the database into another instance:
as your dspace user: pg_dump -o -C -Fc dspace > /tmp/dspace-db.out' pg_restore -c -d dspace /tmp/dspace-db.out' I used the same to upgrade from 7.x to 8.x on multiple DSpace installations. I'd recommend dumping the database and restoring it and your dspace directory in another machine for testing. In our [EMAIL PROTECTED] production environment, Instead of trying to upgrade between major versions of software on the same machine we built a new installation (OS and all software dependencies) in the background and swap out the IPs. We actually keep two practically identical systems hardware wise and upgrade one in the background and rotate them when we feel its ready for production. Alternately we are attempting to put together a fail-over system for the production machine which, again, would be practically identical in configuration. I'd be glad to chat online or over the phone if it would help. -Mark On Jan 19, 2007, at 4:05 PM, Cory Snavely wrote: > That's also something that occurred to me, although I've shied away > from > an upgrade because I haven't seen a good example of how to dump and > restore a DSpace database. As I recall there are issues about objects > and special instructions that must be given in order to preserve them. > > IF anyone has good known-working example for how to do that, that > would > be much appreciated. > > Cory Snavely > University of Michigan Library IT Core Services > > On Fri, 2007-01-19 at 15:40 -0500, Mark H. Wood wrote: >> What version of Postgres are you all running? We used to have these >> problems all the time. I think things got a lot better when I moved >> from the dusty old 7.4 recommended in the docs to 8.0.something and a >> recent JDBC driver. (I'm actually using the 8.1 driver.) >> >> --------------------------------------------------------------------- >> ---- >> 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 > > > ---------------------------------------------------------------------- > --- > 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
