Clean up 1.6 branch.
[Evergreen-DocBook.git] / 1.6 / admin / Upgrading-Evergreen_1.6.xml
diff --git a/1.6/admin/Upgrading-Evergreen_1.6.xml b/1.6/admin/Upgrading-Evergreen_1.6.xml
deleted file mode 100644 (file)
index 1804b8a..0000000
+++ /dev/null
@@ -1,431 +0,0 @@
-<?xml version='1.0' encoding='UTF-8'?>\r
-<chapter xmlns="http://docbook.org/ns/docbook" xmlns:xi="http://www.w3.org/2001/XInclude"\r
-       xmlns:xl="http://www.w3.org/1999/xlink" version="5.0" xml:id="upgradingevergreen">\r
-       <info>\r
-               <title>Upgrading Evergreen to 1.6.1</title>\r
-               <abstract>\r
-                       <para>This Chapter will explain the step-by-step process of upgrading <application>Evergreen\r
-                       </application> to 1.6.1, including steps to upgrade <application>OpenSRF</application>. Before \r
-                       upgrading, it is important to carefully plan an upgrade strategy to minimize system downtime and \r
-                       service interruptions. All of the steps in this chapter are to be completed from the command line.</para>\r
-               </abstract>\r
-       </info>    \r
-               <para>In the following instructions, you are asked to perform certain steps as either the <systemitem class="username">root</systemitem>  or <systemitem class="username">opensrf</systemitem> user.</para>\r
-               <itemizedlist>\r
-                       <listitem>Debian: To become the <systemitem class="username">root</systemitem> user, issue the <command>su</command> command and enter the password of the \r
-                       <systemitem class="username">root</systemitem> user.</listitem>\r
-                       <listitem>Ubuntu: To become the <systemitem class="username">root</systemitem> user, issue the <command>sudo su</command> command and enter the password of your current user.</listitem>\r
-               </itemizedlist>\r
-               <para>To switch from the <systemitem class="username">root</systemitem> user to a different user, issue the <command>su - [user]</command> command; for example, \r
-               <command>su - opensrf</command>. Once you have become a non-root user, to become the <systemitem class="username">root</systemitem> user again simply issue the exit command.</para> \r
-               <para>In the following instructions, <filename class='directory'>/path/to/OpenSRF/</filename> represents the path to the OpenSRF source directory.</para>\r
-       <section xml:id="upgradingevergreen-stop_evergreen">\r
-               <title>Backing Up Data</title>\r
-               <procedure>\r
-                       <step>\r
-                               <para>As <systemitem class="username">root</systemitem>, stop the <application>Apache</application> \r
-                               web server<indexterm><primary>web server</primary><secondary>Apache</secondary></indexterm>.</para>\r
-                       </step>\r
-                       <step>\r
-                               <para>As the <systemitem class="username">opensrf</systemitem> user, stop all \r
-                               <application>Evergreen</application>\r
-                               and <application>OpenSRF</application> services:</para>\r
-                               <screen><userinput>osrf_ctl.sh -l -a stop_all</userinput></screen>\r
-                       </step>\r
-                       <step>\r
-                               <para>Back up of the <filename class='directory'>/openils</filename> \r
-                               directory.</para>\r
-                       </step>\r
-                       <step>\r
-                               <para><link linkend="backingup">Back up the <application>evergreen\r
-                               </application> database</link>.</para>\r
-                       </step>\r
-               </procedure>\r
-       </section>\r
-       <section xml:id="upgradingevergreen-upgradingOpenSRF">\r
-               <title>Upgrading OpenSRF to 1.6</title><indexterm><primary>OpenSRF</primary></indexterm>\r
-               <procedure>\r
-                       <step>\r
-                               <para>As the <systemitem class="username">opensrf</systemitem> user, download and extract the source files for <application>OpenSRF</application> \r
-                               1.6:</para>\r
-<screen><userinput>\r
-wget http://open-ils.org/downloads/opensrf-1.6.3.tar.gz\r
-tar xzf opensrf-1.6.3.tar.gz\r
-</userinput></screen>\r
-                               <para>A new directory opensrf-1.6.3 is created.</para>\r
-                               <note><para>For the latest edition of OpenSRF, check the Evergreen download page at \r
-                               <ulink url="http://www.open-ils.org/downloads.php" />.\r
-                               </para></note>\r
-                       </step>\r
-                       <step>  \r
-                               <para>As the <systemitem class="username">root</systemitem> user, install the software prerequisites using the automatic \r
-                               prerequisite installer.</para> \r
-<screen><userinput>\r
-aptitude install make\r
-cd /home/opensrf/opensrf-1.6.3\r
-</userinput></screen>          \r
-                               <para>Replace <option>[distribution]</option> below with the following value \r
-                               for your distribution:</para>\r
-                               <itemizedlist>\r
-                                       <listitem>\r
-                                               <para><option>debian-etch</option> for <systemitem class="osname">Debian Etch (4.0)</systemitem>\r
-                                               <indexterm><primary>Linux</primary><secondary>Debian</secondary></indexterm></para>\r
-                                       </listitem>\r
-                                       <listitem>\r
-                                               <para><option>debian-lenny</option> for <systemitem class="osname">Debian Lenny (5.0)</systemitem></para>\r
-                                       </listitem>\r
-                                       <listitem>\r
-                                       <para><option>ubuntu-hardy</option> for <systemitem class="osname">Ubuntu Hardy Heron (8.04)</systemitem>\r
-                                       <indexterm><primary>Linux</primary><secondary>Ubuntu</secondary></indexterm></para>\r
-                                       </listitem>\r
-                                       <listitem>\r
-                                               <para><option>ubuntu-intrepid</option> for <systemitem class="osname">Ubuntu Intrepid Ibex \r
-                                               (8.10)</systemitem></para>\r
-                                       </listitem>\r
-                                       <listitem>\r
-                                               <para><option>ubuntu-jaunty</option> for <systemitem class="osname">Ubuntu Jaunty Jackalope \r
-                                               (9.04)</systemitem></para>\r
-                                       </listitem>\r
-                                       <listitem>\r
-                                               <para><option>ubuntu-karmic</option> for <systemitem class="osname">Ubuntu Karmic Koala \r
-                                               (9.10)</systemitem></para>\r
-                                       </listitem>\r
-                                       <listitem>\r
-                                               <para><option>ubuntu-lucid</option> for <systemitem class="osname">Ubuntu Lucid Lynx\r
-                                               (10.04)</systemitem></para>\r
-                                       </listitem>\r
-                                       <listitem>\r
-                                               <para><option>centos</option> for <systemitem class="osname">CentOS 5</systemitem></para>\r
-                                       </listitem>\r
-                               </itemizedlist>\r
-<screen><userinput>\r
-cd /path/to/OpenSRF\r
-make -f src/extras/Makefile.install [distribution]\r
-</userinput></screen>\r
-                               <para>This will install a number of packages required by OpenSRF on your system, \r
-                               including some Perl modules from <systemitem class="resource">CPAN</systemitem><indexterm><primary>Perl</primary><secondary>CPAN</secondary>\r
-                               </indexterm>. You can type <userinput>no</userinput> to the initial <systemitem class="resource">CPAN</systemitem> \r
-                               configuration prompt to allow it to automatically configure itself to download \r
-                               and install Perl modules from <systemitem class="resource">CPAN</systemitem>. The <systemitem class="resource">CPAN</systemitem> installer will ask you a number of \r
-                               times whether it should install prerequisite modules - type <userinput>yes</userinput>.</para>\r
-                       </step>\r
-                       <step>  \r
-                               <para>As the <systemitem class="username">opensrf</systemitem> user, configure and compile OpenSRF:</para> \r
-                               <note>You can include the <option>–enable-python</option> and <option>–enable-java</option> configure options if \r
-                               you want to include support for Python<indexterm><primary>Python</primary></indexterm> and Java\r
-                               <indexterm><primary>Java</primary></indexterm>, respectively.</note>\r
-<screen><userinput>\r
-cd /home/opensrf/opensrf-1.6.3\r
-./configure --prefix=/openils --sysconfdir=/openils/conf\r
-make\r
-</userinput></screen>          \r
-                       </step>\r
-                       <step>  \r
-                               <para>As the <systemitem class="username">root</systemitem> user, return to your OpenSRF build directory and install \r
-                               OpenSRF:</para>\r
-<screen><userinput>\r
-cd /home/opensrf/opensrf-1.6.3\r
-make install\r
-</userinput></screen>\r
-                       </step>\r
-                       <step>\r
-                               <para>As the <systemitem class="username">root</systemitem> user, change the ownership of the installed files to the \r
-                               <systemitem class="username">opensrf</systemitem> user:</para>\r
-                               <screen><userinput>chown -R opensrf:opensrf /openils</userinput></screen>\r
-                       </step>\r
-                       <step>\r
-                               <para>Restart and Test OpenSRF</para>\r
-<screen><userinput>\r
-osrf_ctl.sh -l -a start_all\r
-/openils/bin/srfsh\r
-srfsh#  request opensrf.math add 2 2\r
-</userinput></screen>\r
-                               <para>You should see output such as:</para>\r
-<screen>\r
-Received Data: 4\r
-\r
-------------------------------------\r
-Request Completed Successfully\r
-Request Time in seconds: 0.007519\r
-------------------------------------\r
-\r
-srfsh#\r
-</screen>      \r
-                               <para>If test completed successfully move onto the next section. \r
-                               Otherwise, refer to the <link linkend="troubleshooting">troubleshooting</link> chapter \r
-                               of this documentation.</para> \r
-                       </step> \r
-               </procedure>    \r
-       </section>\r
-       <section xml:id="upgradingevergreen-upgrading_from_1.4_to_1.6.1">\r
-               <title>Upgrade <application>Evergreen</application> from 1.4 to 1.6.1</title>\r
-               <procedure>\r
-                       <step>\r
-                               <para>As the <systemitem class="username">opensrf</systemitem> user, download and extract <application>Evergreen 1.6.1.8</application>\r
-                               </para>\r
-<screen><userinput>\r
-wget http://open-ils.org/downloads/Evergreen-ILS-1.6.1.8.tar.gz\r
-tar xzf Evergreen-ILS-1.6.1.8.tar.gz\r
-</userinput></screen>\r
-                               <note><para>For the latest edition of Evergreen check the Evergreen download page at\r
-                               <ulink url="http://www.open-ils.org/downloads.php" /> and adjust upgrading instructions accordingly.</para></note>\r
-                       </step>\r
-                       <step>\r
-                               <para>As the <systemitem class="username">root</systemitem> user, install the prerequisites:</para> \r
-                               <screen><userinput>cd /home/opensrf/Evergreen-ILS-1.6.1.8</userinput></screen>  \r
-                               <para>On the next command, replace <option>[distribution]</option> with one of \r
-                               these values for your distribution of Debian or Ubuntu:</para>\r
-                               <itemizedlist>\r
-                                       <listitem>\r
-                                               <para><option>debian-etch</option> for <systemitem class="osname">Debian Etch (4.0)</systemitem></para><indexterm><primary>Linux</primary><secondary>Debian</secondary></indexterm>\r
-                                       </listitem>\r
-                                       <listitem>\r
-                                               <para><option>debian-lenny</option> for <systemitem class="osname">Debian Lenny (5.0)</systemitem></para>\r
-                                       </listitem>\r
-                                       <listitem>\r
-                                               <para><option>ubuntu-hardy</option> for <systemitem class="osname">Ubuntu Hardy Heron \r
-                                               (8.04)</systemitem></para><indexterm><primary>Linux</primary><secondary>Ubuntu</secondary></indexterm>\r
-                                       </listitem>\r
-                                       <listitem>\r
-                                               <para><option>ubuntu-intrepid</option> for <systemitem class="osname">Ubuntu Intrepid Ibex \r
-                                               (8.10)</systemitem></para>\r
-                                       </listitem>\r
-                                       <listitem>\r
-                                               <para><option>ubuntu-jaunty</option> for <systemitem class="osname">Ubuntu Jaunty Jackalope \r
-                                               (9.04)</systemitem></para>\r
-                                       </listitem>\r
-                                       <listitem>\r
-                                               <para><option>ubuntu-karmic</option> for <systemitem class="osname">Ubuntu Karmic Koala \r
-                                               (9.10)</systemitem> or <systemitem class="osname">Ubuntu Lucid Lynx \r
-                                               (10.04)</systemitem></para>\r
-                                       </listitem>\r
-                               </itemizedlist>\r
-                               <screen><userinput>make -f Open-ILS/src/extras/Makefile.install <option>[distribution]</option></userinput></screen>\r
-                       </step>\r
-                       <step>\r
-                               <para>As the <systemitem class="username">opensrf</systemitem> user, configure and compile \r
-                               <application>Evergreen</application>:</para>\r
-                               <screen><userinput>cd /home/opensrf/Evergreen-ILS-1.6.1.8</userinput></screen>\r
-                               <screen><userinput>./configure --prefix=/openils --sysconfdir=/openils/conf</userinput></screen>\r
-                               <screen><userinput>make</userinput></screen>\r
-                       </step>\r
-                       <step>\r
-                               <para>As the <systemitem class="username">root</systemitem> user, install \r
-                               <application>Evergreen</application>:</para>\r
-                               <screen><userinput>make STAFF_CLIENT_BUILD_ID=rel_1_6_1_8 install</userinput></screen>\r
-                       </step>\r
-                       <step>\r
-                               <para>Change to the <application>Evergreen</application> installation \r
-                               directory:</para>\r
-                               <screen><userinput>cd /home/opensrf/Evergreen-ILS-1.6.1.8</userinput></screen>\r
-                       </step>\r
-                       <step>\r
-                               <para>As the <emphasis>root</emphasis> user, change all files to be owned by the \r
-                               <emphasis>opensrf</emphasis> user and group:</para>\r
-                               <screen><userinput>chown -R opensrf:opensrf /openils</userinput></screen>\r
-                       </step>                 \r
-                       <step>\r
-                               <para>As the <systemitem class="username">root</systemitem> user, build <filename>live-db-setup.pl</filename> for the cgi-bin \r
-                               bootstrapping scripts and <filename>offline-config.pl</filename> for the offline staff client data uploader:</para>\r
-<screen><userinput>\r
-cd /home/opensrf/Evergreen-ILS-1.6.1.8\r
-perl Open-ILS/src/support-scripts/eg_db_config.pl --create-bootstrap --create-offline \ \r
---user evergreen --password evergreen --hostname localhost --port 5432 \\r
---database evergreen\r
-</userinput></screen>\r
-                       </step>\r
-                       <step>\r
-                               <para>As the <systemitem class="username">opensrf</systemitem> user, update server symlink in <filename class="directory">/openils/var/web/xul/</filename>:</para>\r
-<screen><userinput>\r
-cd /openils/var/web/xul/\r
-rm server\r
-ln -s rel_1_6_1_8/server\r
-</userinput></screen>\r
-                       </step>\r
-                       <step>\r
-                               <para>Update the Evergreen database:</para>\r
-                               <note><para>it is recommended that you <link linkend="backingup">back up your Evergreen database</link> in order to restore your data if anything goes wrong.</para></note>\r
-<screen>\r
-<userinput>\r
-psql -U evergreen -h localhost -f Open-ILS/src/sql/Pg/1.4.0.5-1.6.0.0-upgrade-db.sql evergreen\r
-psql -U evergreen -h localhost -f Open-ILS/src/sql/Pg/1.6.0.0-1.6.0.1-upgrade-db.sql evergreen\r
-psql -U evergreen -h localhost -f Open-ILS/src/sql/Pg/1.6.0.1-1.6.0.2-upgrade-db.sql evergreen\r
-psql -U evergreen -h localhost -f Open-ILS/src/sql/Pg/1.6.0.2-1.6.0.3-upgrade-db.sql evergreen \r
-psql -U evergreen -h localhost -f Open-ILS/src/sql/Pg/1.6.0.3-1.6.0.4-upgrade-db.sql evergreen\r
-psql -U evergreen -h localhost -f Open-ILS/src/sql/Pg/1.6.0.4-1.6.1.0-upgrade-db.sql evergreen\r
-psql -U evergreen -h localhost -f Open-ILS/src/sql/Pg/1.6.1.0-1.6.1.1-upgrade-db.sql evergreen\r
-psql -U evergreen -h localhost -f Open-ILS/src/sql/Pg/1.6.1.1-1.6.1.2-upgrade-db.sql evergreen\r
-psql -U evergreen -h localhost -f Open-ILS/src/sql/Pg/1.6.1.2-1.6.1.3-upgrade-db.sql evergreen\r
-psql -U evergreen -h localhost -f Open-ILS/src/sql/Pg/1.6.1.3-1.6.1.4-upgrade-db.sql evergreen\r
-psql -U evergreen -h localhost -f Open-ILS/src/sql/Pg/1.6.1.4-1.6.1.5-upgrade-db.sql evergreen\r
-psql -U evergreen -h localhost -f Open-ILS/src/sql/Pg/1.6.1.5-1.6.1.6-upgrade-db.sql evergreen\r
-psql -U evergreen -h localhost -f Open-ILS/src/sql/Pg/1.6.1.6-1.6.1.7-upgrade-db.sql evergreen\r
-psql -U evergreen -h localhost -f Open-ILS/src/sql/Pg/1.6.1.8-1.6.1.8-upgrade-db.sql evergreen\r
-</userinput>\r
-</screen>      \r
-                       </step>\r
-                       <step>\r
-                               <para>As the <systemitem class="username">opensrf</systemitem> user, \r
-                               copy <filename>/openils/conf/oils_web.xml.example</filename> to <filename>/openils/conf/oils_web.xml</filename>\r
-                               <indexterm><primary>configuration files</primary><secondary>oils_web.xml</secondary></indexterm>\r
-                               (needed for acquisitions templates).</para>\r
-                               <screen><userinput>cp /openils/conf/oils_web.xml.example /openils/conf/oils_web.xml</userinput></screen>\r
-                       </step>\r
-                       <step>\r
-                               <para>Update <filename>opensrf_core.xml</filename> and <filename>opensrf.xml</filename> by copying the new example files \r
-                               (<filename>/openils/conf/opensrf_core.xml.example</filename> and <filename>/openils/conf/opensrf.xml</filename>).</para>\r
-                               <indexterm><primary>configuration files</primary><secondary>opensrf.xml</secondary></indexterm>\r
-                               <screen><userinput>cp /openils/conf/opensrf_core.xml.example /openils/conf/opensrf_core.xml</userinput></screen>\r
-                               <indexterm><primary>configuration files</primary><secondary>opensrf_core.xml</secondary></indexterm>\r
-                               <screen><userinput>cp /openils/conf/opensrf.xml.example /openils/conf/opensrf.xml</userinput></screen>\r
-                       </step>\r
-                       <step>\r
-                               <para>Update <filename>opensrf.xml</filename> with the database connection info:</para>\r
-<screen><userinput>\r
-perl Open-ILS/src/support-scripts/eg_db_config.pl --update-config --service all --user evergreen \\r
---password evergreen --hostname localhost --port 5432 --database evergreen\r
-</userinput></screen>\r
-                       </step>\r
-                       <step>\r
-                               <para>Update /etc/apache2/startup.pl by copying the example from \r
-                               Open-ILS/examples/apache/startup.pl.</para><indexterm><primary>configuration files</primary><secondary>startup.pl</secondary></indexterm>\r
-                       </step>\r
-                       <step>\r
-                               <para>Update /etc/apache2/eg_vhost.conf by copying the example from \r
-                               Open-ILS/examples/apache/eg_vhost.conf.</para><indexterm><primary>configuration files</primary><secondary>eg_vhost.conf</secondary></indexterm>\r
-                       </step>\r
-                       <step>\r
-                       <para>Update /etc/apache2/sites-available/eg.conf by copying the example from Open-ILS/\r
-                       examples/apache/eg.conf.</para><indexterm><primary>configuration files</primary><secondary>eg.conf</secondary></indexterm>\r
-                       </step>\r
-                       <step>\r
-                               <para>Recover customizations you have made to the <application>Apache</application><indexterm><primary>Apache</primary></indexterm> \r
-                               configuration files. For example, if you purchased an SSL certificate, you \r
-                               will need to edit <filename>eg.conf</filename> to point to the appropriate SSL certificate files.</para>\r
-                               <indexterm><primary>SSL</primary><secondary>certificates</secondary></indexterm>\r
-                       </step> \r
-               </procedure>    \r
-       </section>\r
-       <section xml:id="upgradingevergreen_1.6.0_to_1.6.1">\r
-               <title>Upgrade <application>Evergreen</application> from 1.6.0 to 1.6.1</title>\r
-               <procedure>\r
-                       <step>\r
-                               <para>Follow steps 1-8 of the <link linkend="upgradingevergreen-upgrading_from_1.4_to_1.6.1">instructions for upgrading Evergreen from 1.4</link></para> \r
-                               \r
-                       </step>\r
-                       <step>\r
-                               <para>Update the Evergreen database:</para>\r
-                               <note><para>It is recommended that you <link linkend="backingup">back up your Evergreen database</link> in order to restore your data if anything goes wrong.</para></note>\r
-<screen>\r
-<userinput>\r
-psql -U evergreen -h localhost -f Open-ILS/src/sql/Pg/1.6.0.4-1.6.1.0-upgrade-db.sql evergreen\r
-psql -U evergreen -h localhost -f Open-ILS/src/sql/Pg/1.6.1.0-1.6.1.1-upgrade-db.sql evergreen\r
-psql -U evergreen -h localhost -f Open-ILS/src/sql/Pg/1.6.1.1-1.6.1.2-upgrade-db.sql evergreen\r
-psql -U evergreen -h localhost -f Open-ILS/src/sql/Pg/1.6.1.2-1.6.1.3-upgrade-db.sql evergreen\r
-psql -U evergreen -h localhost -f Open-ILS/src/sql/Pg/1.6.1.3-1.6.1.4-upgrade-db.sql evergreen\r
-psql -U evergreen -h localhost -f Open-ILS/src/sql/Pg/1.6.1.4-1.6.1.5-upgrade-db.sql evergreen\r
-psql -U evergreen -h localhost -f Open-ILS/src/sql/Pg/1.6.1.5-1.6.1.6-upgrade-db.sql evergreen\r
-psql -U evergreen -h localhost -f Open-ILS/src/sql/Pg/1.6.1.6-1.6.1.7-upgrade-db.sql evergreen\r
-psql -U evergreen -h localhost -f Open-ILS/src/sql/Pg/1.6.1.7-1.6.1.8-upgrade-db.sql evergreen\r
-</userinput>\r
-</screen>      \r
-                       </step>\r
-                       <step>\r
-                               <para>Follow steps 10-16 of the <link linkend="upgradingevergreen-upgrading_from_1.4_to_1.6.1">instructions for upgrading Evergreen from 1.4</link></para>\r
-                               \r
-                       \r
-                       </step>\r
-               </procedure>    \r
-       </section>\r
-       <section xml:id="testing_after_upgrade">\r
-               <title>Restart Evergreen and Test</title>\r
-               <procedure>\r
-                       <step>\r
-                               <para>As the <systemitem class="username">opensrf</systemitem> user, start all \r
-                               <application>Evergreen</application> and <application>OpenSRF</application> \r
-                               services:</para>\r
-                               <screen><userinput>osrf_ctl.sh -l -a start_all</userinput></screen>\r
-                       </step>\r
-                       <step>\r
-                               <para>As the <systemitem class="username">opensrf</systemitem> user, run <command>autogen</command> to refresh the static \r
-                               organizational data files:</para><indexterm><primary>autogen</primary></indexterm>\r
-<screen><userinput>\r
-cd /openils/bin\r
-./autogen.sh -c /openils/conf/opensrf_core.xml -u\r
-</userinput></screen>\r
-                                       \r
-                       </step>\r
-                       <step>\r
-                               <para>Start <command>srfsh</command> and try logging in  using your <application>Evergreen</application>\r
-                               username and password:</para>\r
-<screen>\r
-<userinput>/openils/bin/srfsh</userinput>\r
-<prompt>srfsh%</prompt> <userinput>login <option>username</option> <option>password</option></userinput>\r
-</screen> \r
-                       </step> \r
-                       <step>\r
-                               <para>Start the <application>Apache</application> web server.</para>\r
-                       </step>\r
-               </procedure>\r
-               <note>\r
-                       <para>If you encounter errors, refer to the <link linkend="troubleshooting">troubleshooting \r
-                       section</link> of this documentation for tips \r
-                       on finding solutions and seeking further assistance from the Evergreen community.</para>  \r
-               </note>\r
-       </section>\r
-       <section xml:id="upgrading_Postgresqlto8.4">\r
-               <title>Upgrading PostgreSQL from 8.2 to 8.4</title>\r
-               <para>Evergreen 1.6.1 supports PostgreSQL version 8.4 and it is recommended that you upgrade PostgreSQL when you upgrade Evergreen to 1.6.</para>\r
-               <note><para>The order of the following steps is very important.</para></note><indexterm><primary>databases</primary><secondary>PostgreSQL</secondary></indexterm>\r
-               <procedure>\r
-                       <step>\r
-                               <para>As <systemitem class="username">opensrf</systemitem>, stop the evergreen and opensrf services:</para>\r
-                               <screen><userinput>osrf_ctl.sh -l -a stop_all</userinput></screen>\r
-                       </step>                 \r
-                       <step>\r
-                               <para><link linkend="backingup">Backup the Evergreen database data</link></para>\r
-                       </step>\r
-                       <step>\r
-                               <para>Upgrade to Postgresql 8.4 by removing old version and installing Postgresql 8.4</para>\r
-                       </step>\r
-                       <step>                  \r
-                               <para>Create an empty Evergreen database in postgresql 8.4 by issuing the following commands as the postgres user:</para>\r
-<screen>\r
-<userinput>\r
-createdb -E UNICODE evergreen\r
-createlang plperl   evergreen\r
-createlang plperlu  evergreen\r
-createlang plpgsql  evergreen\r
-psql -f /usr/share/postgresql/8.4/contrib/tablefunc.sql evergreen\r
-psql -f /usr/share/postgresql/8.4/contrib/tsearch2.sql evergreen\r
-psql -f /usr/share/postgresql/8.4/contrib/pgxml.sql evergreen\r
-</userinput>\r
-</screen>              \r
-                       </step>\r
-                       <step>\r
-                               <para>As the <systemitem class="username">postgres</systemitem> user on the PostgreSQL server, create a PostgreSQL user named <systemitem class="username">evergreen</systemitem> for the database cluster:</para>\r
-                               <screen><userinput>createuser -P -s evergreen</userinput></screen>\r
-                               <para>Enter the password for the new PostgreSQL superuser (<systemitem class="username">evergreen</systemitem>)</para>  \r
-                       </step>                 \r
-                       <step>\r
-                               <para>Restore data from backup created in step 1.</para>\r
-                       </step>\r
-                       <step>\r
-                               <para>To point tsearch2 to proper function names in 8.4, run the SQL script \r
-                               <filename>/home/opensrf/Evergreen-ILS*/Open-ILS/src/sql/Pg/000.english.pg84.fts-config.sql</filename> using the <command>psql</command> command.</para>\r
-                               <screen><userinput>cd /home/opensrf/Evergreen-ILS*</userinput></screen>\r
-                               <screen><userinput>psql -f /Open-ILS/src/sql/Pg/000.english.pg84.fts-config.sql evergreen</userinput></screen>\r
-                       </step>\r
-                       <step>\r
-                               <para><link linkend="startingopensrf">Restart Evergreen and OpenSRF services</link></para>\r
-                       </step>\r
-                       <step>\r
-                               <para>For additional information regarding upgrading PostgreSQL, see the following documentation in PostgreSQL:</para>\r
-                               <para><ulink url="http://www.postgresql.org/docs/8.4/static/install-upgrading.html" /></para>\r
-                               <para><ulink url="http://www.postgresql.org/docs/8.4/interactive/textsearch-migration.html" /> \r
-                               </para>\r
-                               <para><ulink url="http://www.postgresql.org/docs/current/static/tsearch2.html#AEN102824" /></para>\r
-                       </step>\r
-               </procedure>\r
-       </section>\r
-</chapter>\r