[OPEN-ILS-DEV] upgrade sql script

[Soulliere, Robert]

Thanks for all your assistance and tips everyone.

Using the option:

-veg_version=NULL

in the psql command works well.

I have a few things to clean up related to past updates in this test database, but this put me on the right track.

After examining my original email, I see I need to do more careful spell and typo checking before hitting send. ;-)

Regards,
Robert

Robert Soulliere, BA (Hons), MLIS
Systems Librarian
Mohawk College Library
robert.soulliere at mohawkcollege.ca
Telephone: 905 575 1212 x3936
Fax: 905 575 2011
________________________________________
From: open-ils-dev-bounces at list.georgialibraries.org [open-ils-dev-bounces at list.georgialibraries.org] On Behalf Of Peters, Michael [MRPeters at library.IN.gov]
Sent: February 9, 2012 11:59 AM
To: Evergreen Development Discussion List
Subject: Re: [OPEN-ILS-DEV] upgrade sql script

Sorry for the bad advice, Robert.

Sincerely,
Michael Peters
Indiana State Library MIS | Inspire.IN.gov Helpdesk | Evergreen Indiana Helpdesk
office - 317.234.2128
email - mrpeters at library.in.gov


-----Original Message-----
From: open-ils-dev-bounces at list.georgialibraries.org [mailto:open-ils-dev-bounces at list.georgialibraries.org] On Behalf Of Peters, Michael
Sent: Thursday, February 09, 2012 11:35 AM
To: Evergreen Development Discussion List
Subject: Re: [OPEN-ILS-DEV] upgrade sql script

I could be wrong, but isn't this a job for update_db.sh?

Something like:

/home/opensrf/Evergreen/build/tools/update_db.sh localhost evergreen evergreen  (while in Open-ILS/src/sql/Pg)

Sincerely,
Michael Peters
Indiana State Library MIS | Inspire.IN.gov Helpdesk | Evergreen Indiana Helpdesk
office - 317.234.2128
email - mrpeters at library.in.gov


-----Original Message-----
From: open-ils-dev-bounces at list.georgialibraries.org [mailto:open-ils-dev-bounces at list.georgialibraries.org] On Behalf Of Thomas Berezansky
Sent: Thursday, February 09, 2012 11:05 AM
To: Evergreen Development Discussion List
Subject: Re: [OPEN-ILS-DEV] upgrade sql script

For the psql command try adding -veg_version=NULL to define the
eg_version variable.

Thomas Berezansky
Merrimack Valley Library Consortium


Quoting "Soulliere, Robert" <robert.soulliere at mohawkcollege.ca>:

> Hi all,
>
> I am trying to run the 2.2. database upgrade script on a test server:
>
> 2.1-2.2-upgrade-db.sql.
>
> with the command:
> psql -U evergreen -f 2.1-2.2-upgrade-db.sql evergreen
>
> However, I am getting the following syntax errors:
>
> psql:2.1-2.2-upgrade-db.sql:6256: ERROR:  syntax error at or near ":"
> LINE 1: SELECT evergreen.upgrade_deps_block_check('0647', :eg_versio...
>
> So far the only way I know how to avoid these error and complete the
> upgrade script is to comment out all the
> "SELECT evergreen.upgrade_deps_block_check('0651', :eg_versio..."
> lines in the scripts.
>
> Obviously, that doesn't seem like to correct path so solve this
> issue since this is supposed to check for preciously installed
> updates.
>
> I am wondering if these errors are occurring because I am missing a
> postgresql language install or if a previous upgrade might be missing?
>
> I am installing from trunk and am tried this on both postgresql 9.0
> and 9.1 systems.
>
> Thanks,
> Robert
>
>
>
> Robert Soulliere, BA (Hons), MLIS
> Systems Librarian
> Mohawk College Library
> robert.soulliere at mohawkcollege.ca
> Telephone: 905 575 1212 x3936
> Fax: 905 575 2011
>
> This E-mail contains privileged and confidential information intended
> only for the individual or entity named in the message.  If the reader
> of this message is not the intended recipient, or the agent responsible
> to deliver it to the intended recipient, you are hereby notified that
> any review, dissemination, distribution or copying of this communication
> is prohibited.  If this communication was received in error, please
> notify the sender by reply E-mail immediately, and delete and destroy
> the original message.
>



This E-mail contains privileged and confidential information intended
only for the individual or entity named in the message.  If the reader
of this message is not the intended recipient, or the agent responsible
to deliver it to the intended recipient, you are hereby notified that
any review, dissemination, distribution or copying of this communication
is prohibited.  If this communication was received in error, please
notify the sender by reply E-mail immediately, and delete and destroy
the original message.