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

[Dan Scott]

Password, user name, host name, port, and database name get pulled from
opensrf.xml if not supplied, so they would be unnecessary in this case too.
On Feb 10, 2012 12:19 PM, "Bill Erickson" <erickson at esilibrary.com> wrote:

> On Fri, Feb 10, 2012 at 12:05:28PM -0500, Yamil Suarez wrote:
> >
> > On Feb 10, 2012, at 11:47 AM, Bill Erickson wrote:
> >
> > >On Fri, Feb 10, 2012 at 11:30:39AM -0500, Yamil Suarez wrote:
> > >
> > >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
> >
> >
> > This makes my day!
> >
> > In this case, I do not care about the data I stored up to now in the DB.
> >
> > To be absolutely clear, I can re-run the eg_db_config.pl the same
> > way that I did when I first installed, with all of the same
> > parameters?
> >
> > For example...
> >
> > perl Open-ILS/src/support-scripts/eg_db_config.pl --update-config \
> >        --service all --create-database --create-schema --create-offline
> > \
> >        --user evergreen --password evergreen --hostname localhost --port
> > 5432 \
> >        --database evergreen --admin-user admin --admin-pass
> > xxxxxxxxxx ;
>
> Some of the parameters are unnecessary.  I think this should do it:
>
> perl Open-ILS/src/support-scripts/eg_db_config.pl
>    --create-schema         \
>    --user evergreen        \
>    --password xxxxxxxxx    \
>    --hostname localhost    \
>    --port 5432             \ # not required for port=5432
>    --database evergreen    \
>    --admin-user admin      \
>    --admin-pass xxxxxxx
>
> Change to suit.
>
> -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
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://libmail.georgialibraries.org/pipermail/open-ils-general/attachments/20120210/ebddf136/attachment.htm>