Yes I think so. Here is what seems to work: 1) dump the Evergreen database data with a standard dump.
2) upgrade to Postgresql 8.3 3) create an empty Evergreen database in postgresql 8.3 -- follow all of step 3 and 4 of Evergreen installation instructions. 4) restore data from dump (might see errors here but don't panic as suggested in postgresql docs. below). 5) To point tsearch2 to proper function names in 8.3 I ran the SQL script 000.english.pg83.fts-config.sql using psql after restoring the data. This sql script is located in the repository: http://svn.open-ils.org/trac/ILS/browser/trunk/Open-ILS/src/sql/Pg/000.english.pg83.fts-config.sql . This fixes errors related to tsearch2 functions not being found since it configures Evergreen to point to the proper tsearch2 function names. Please see the following postgresql documentation for more information on upgrading steps and fixing tsearch2 after upgrading: http://www.postgresql.org/docs/8.3/static/install-upgrading.html http://www.postgresql.org/docs/8.3/interactive/textsearch-migration.html http://www.postgresql.org/docs/current/static/tsearch2.html#AEN102824 Before trying this please note that I have done this on a test server but not on our production server. You might also wait for some of the database experts on the list to chime in here for better procedures. For example, some cleanup may be necessary. This did work for us and I was able to migrate data from postgresql 8.2 to 8.3 and get everything working. I also wonder if there will be an official sql script to run for upgrades to 8.2 to 8.3 for Evergreen users or if the existing script mentioned above is sufficient? Thanks, Robert Robert Soulliere Systems Librarian [email protected] Tel: 905-575-1212 X3936 libr...@mohawk Connect * Learn * Succeed brain.mohawkcollege.ca -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Steve Wills Sent: March 12, 2010 10:35 AM To: Evergreen Development Discussion List Subject: Re: [OPEN-ILS-DEV] upgrading postgresql 8.2 to 8.3 with Evergreen database I am having this problem also. Robert, did you solve the problem or drop back to Pg8.2? Thanks, Stev3 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.
