On Fri, Feb 10, 2012 at 11:30:39AM -0500, Yamil Suarez wrote: > Hello everyone, > > I think I just mucked up the data in my tests server by prematurely > canceling out of a batch import. I would love to be able to > reinstall an fresh Evergreen postgres schema like I had when I > installed evergreen a couple of days ago. Additionally there are > other testing reasons that make me want to start fresh instead of > spending time cleaning up the problems I created. > > I suspect that the process could more or less consist of dropping/ > deleting the evergreen database instance, and then maybe running a > version of eg_db_config.pl? > > This EG wiki page has an explanation of how to restore the EG db > from a back up, which I might be able to use for syntax ideas to do > what I want, but I would like to get some feedback from the > community first. > http://www.open-ils.org/dokuwiki/doku.php?id=evergreen-admin:maintenance:backups&s[]=database&s[]=backup
Hi Yamil, If you just want to apply the updated schema and are willing to lose your data, all you need to do is re-run eg_db_config.pl. It will drop the schema (and all of your data!) and re-build the schema. -b -- Bill Erickson | Senior Software Developer | Equinox Software, Inc. / Your Library's Guide to Open Source | phone: 877-OPEN-ILS (673-6457) | email: [email protected] | web: http://esilibrary.com
