[OPEN-ILS-GENERAL] How do I go back to a clean EG/postgres schema?

[Bill Erickson]

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: erickson at esilibrary.com
| web: http://esilibrary.com