[OPEN-ILS-DEV] upgrading postgresql 8.2 to 8.3 with Evergreen database

[Soulliere, Robert]

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
robert.soulliere at mohawkcollege.ca
Tel: 905-575-1212 X3936

Library at Mohawk
Connect * Learn * Succeed
brain.mohawkcollege.ca


-----Original Message-----
From: open-ils-dev-bounces at list.georgialibraries.org [mailto:open-ils-dev-bounces at list.georgialibraries.org] 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.