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 :
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.soulli...@mohawkcollege.ca:
Hi all,
I am trying to run the 2.2. database upgrade script on a test server:
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.soulli...@mohawkcollege.ca:
Hi all,
I am trying to run
On Thu, Feb 9, 2012 at 11:35 AM, Peters, Michael
mrpet...@library.in.gov wrote:
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)
*RED ALERT* That's not a
As the person who does the upgrades for the only production site
running master that I am aware of, I avoid update_db.sh even then.
Instead, I dump all the upgrade scripts into a single file with cat
and manually review each of them to look for potential issues, such as
assumptions that we
-ils-dev-boun...@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
...@list.georgialibraries.org
[open-ils-dev-boun...@list.georgialibraries.org] On Behalf Of Peters, Michael
[mrpet...@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