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 - [email protected] -----Original Message----- From: [email protected] [mailto:[email protected]] 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" <[email protected]>: > 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 > [email protected] > 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. >
