+++ /dev/null
-<?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-2.0">\r
- <info>\r
- <title>Upgrading Evergreen to 2.0</title>\r
- <abstract>\r
- <para>This Chapter will explain the step-by-step process of upgrading <application>Evergreen\r
- </application> to 2.0, 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
- \r
- </abstract>\r
- </info> \r
- <para>Evergreen 2.0 has several software requirements:</para>\r
- <itemizedlist>\r
- <listitem>PostgreSQL: Version 8.4 is the minimum supported version of PostgreSQL. </listitem>\r
- <listitem>Linux: Evergreen 2.0 has been tested on Debian Squeeze (6.0) and Ubuntu Lucid Lynx (10.04). If you are running an older version of these distributions, \r
- you may want to upgrade befor installing Evergreen 2.0. For instructions on upgrading these distributions, visit the \r
- <ulink url="http://www.debian.org/releases/squeeze/">Debian</ulink> or <ulink url="https://help.ubuntu.com/community/LucidUpgrades">Ubuntu</ulink> websites.</listitem>\r
- </itemizedlist>\r
- <para>In the following instructions, you are asked to perform certain steps as either the <systemitem class="username">root</systemitem> or \r
- <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 2.0</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
- 2.0:</para>\r
-<screen><userinput>\r
-wget http://open-ils.org/downloads/opensrf-2.0.1.tar.gz\r
-tar xzf opensrf-2.0.1.tar.gz\r
-</userinput></screen>\r
- <para>A new directory opensrf-2.0.1 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-2.0.1\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-squeeze</option> for <systemitem class="osname">Debian Squeeze (6.0)</systemitem>\r
- <indexterm><primary>Linux</primary><secondary>Debian</secondary></indexterm></para>\r
- </listitem>\r
- <listitem>\r
- <para><option>fedora13</option> for <systemitem class="osname">Fedora 13</systemitem>\r
- <indexterm><primary>Linux</primary><secondary>Fedora</secondary></indexterm></para>\r
- </listitem> \r
- <listitem>\r
- <para><option>ubuntu-lucid</option> for <systemitem class="osname">Ubuntu Lucid Lynx\r
- (10.04)</systemitem><indexterm><primary>Linux</primary><secondary>Ubuntu</secondary></indexterm></para>\r
- </listitem>\r
- <listitem>\r
- <para><option>centos</option> for <systemitem class="osname">CentOS 5</systemitem>\r
- <indexterm><primary>Linux</primary><secondary>CentOS</secondary></indexterm></para>\r
- </listitem>\r
- <listitem>\r
- <para><option>rhel</option> for <systemitem class="osname">Red Hat Enterprise Linux 5</systemitem>\r
- <indexterm><primary>Linux</primary><secondary>Red Hat</secondary></indexterm></para>\r
- </listitem>\r
- </itemizedlist>\r
-<screen><userinput>\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-2.0.1\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-2.0.1\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>Jot down the usernames/passwords of the two Jabber users created when OpenSRF was previously installed these users will correspond to \r
- entries in opensrf_core.xml. </para>\r
- </step>\r
- <step>\r
- <para>Important: Backup your current opensrf.xml and opensrf_core.xml configuration files.</para>\r
-<screen>\r
-<userinput>cp -p /openils/conf/opensrf.xml /openils/conf/opensrf.xml.backup</userinput>\r
-<userinput>cp -p /openils/conf/opensrf_core.xml /openils/conf/opensrf_core.xml.backup</userinput>\r
-</screen>\r
- </step>\r
- <step>\r
- <para>As the <systemitem class="username">opensrf</systemitem> user, copy the <filename>/openils/conf/opensrf_core.xml</filename> and \r
- <filename>/openils/conf/opensrf.xml</filename> configuration files from the example templates:</para>\r
-<screen>\r
-<userinput>cp /openils/conf/opensrf.xml.example /openils/conf/opensrf.xml</userinput>\r
-<userinput>cp /openils/conf/opensrf_core.xml.example /openils/conf/opensrf_core.xml</userinput>\r
-</screen>\r
- <para>Edit <filename>/openils/conf/opensrf_core.xml</filename> to change the Jabber usernames and passwords you jotted down earlier.</para> \r
- </step>\r
- <step>\r
- <para>As the <systemitem class="username">root</systemitem> user, Run the following command:</para>\r
-<screen>\r
-<userinput>ldconfig</userinput>\r
-</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
- </step> \r
- <step> \r
- <para>If test completed successful restore your Evergreen configuration files:</para>\r
-<screen><userinput>\r
-cp /openils/conf/opensrf.xml.backup /openils/conf/opensrf.xml\r
-cp /openils/conf/opensrf_core.xml.backup /openils/conf/opensrf_core.xml\r
-</userinput></screen>\r
- \r
- <para>and move on to the next section to upgrade Evergreen. 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.6_to_2.0">\r
- <title>Upgrade <application>Evergreen</application> from 1.6.1 to 2.0</title>\r
- <note>\r
- <para>PostgreSQL 8.4 is the minimum supported version of PostgreSQL.</para> \r
- <para>Evergreen 2.0 has been tested on Debian Squeeze (6.0) and Ubuntu Lucid (10.04). If you are runnung an older version of \r
- these distributions, you may want to upgrade befor installing Evergreen 2.0. For instructions on upgrading these distribuitions, visit the \r
- <ulink url="http://www.debian.org/releases/squeeze/">Debian</ulink> or <ulink url="https://help.ubuntu.com/community/LucidUpgrades">Ubuntu</ulink> websites.</para>\r
- </note>\r
- <procedure>\r
- <step>\r
- <para>As the <systemitem class="username">opensrf</systemitem> user, download and extract <application>Evergreen 2.0</application>\r
- </para>\r
-<screen><userinput>\r
-wget http://www.open-ils.org/downloads/Evergreen-ILS-2.0.9.tar.gz\r
-tar xzf Evergreen-ILS-2.0.9.tar.gz\r
-</userinput></screen>\r
- <note><para>For the latest edition of Evergreen 2.0, 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-2.0.9</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
- \r
- <listitem>\r
- <para><option>debian-squeeze</option> for <systemitem class="osname">Debian Squeeze (6.0)</systemitem></para>\r
- </listitem>\r
- \r
- <listitem>\r
- <para><option>ubuntu-lucid</option> for <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-2.0.9</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_2_0_9 install</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">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_2_0_9/server\r
-</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-2.0.9</userinput></screen>\r
- </step>\r
-\r
- <step>\r
- <para>Update the <database>evergreen</database> 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
- <note><para>The <filename>1.6.1-2.0-upgrade-db.sql</filename> upgrade script may take a long time (hours) to process \r
- on larger systems.</para></note>\r
-<screen>\r
-<userinput>\r
-psql -U evergreen -h localhost -f Open-ILS/src/sql/Pg/1.6.1-2.0-upgrade-db.sql evergreen\r
-psql -U evergreen -h localhost -f Open-ILS/src/sql/Pg/2.0.0-2.0.1-upgrade-db.sql evergreen\r
-psql -U evergreen -h localhost -f Open-ILS/src/sql/Pg/2.0.1-2.0.2-upgrade-db.sql evergreen\r
-psql -U evergreen -h localhost -f Open-ILS/src/sql/Pg/2.0.2-2.0.3-upgrade-db.sql evergreen\r
-psql -U evergreen -h localhost -f Open-ILS/src/sql/Pg/2.0.3-2.0.4-upgrade-db.sql evergreen\r
-psql -U evergreen -h localhost -f Open-ILS/src/sql/Pg/2.0.4-2.0.5-upgrade-db.sql evergreen\r
-psql -U evergreen -h localhost -f Open-ILS/src/sql/Pg/2.0.5-2.0.6-upgrade-db.sql evergreen\r
-psql -U evergreen -h localhost -f Open-ILS/src/sql/Pg/2.0.6-2.0.7-upgrade-db.sql evergreen\r
-psql -U evergreen -h localhost -f Open-ILS/src/sql/Pg/2.0.7-2.0.8-upgrade-db.sql evergreen\r
-psql -U evergreen -h localhost -f Open-ILS/src/sql/Pg/2.0.8-2.0.9-upgrade-db.sql evergreen\r
-\r
-</userinput>\r
-</screen> \r
- \r
- </step>\r
-<step>\r
- <para>Run the <filename>reingest-1.6-2.0.pl</filename> script to generate an sql script. Then use the sql file to reingest bib records into your \r
- <database>evergreen</database> database. This is required to make the new facet sidebar in OPAC search results work and to upgrade the keyword indexes to use \r
- the revised NACO normalization routine.</para>\r
- <note><para>If you are running a large Evergreen installation, it is recommend that you examine the script first. Reingesting a large number of bibliographic records \r
- may take several hours.</para></note>\r
-<screen><userinput>perl Open-ILS/src/sql/Pg/reingest-1.6-2.0.pl</userinput></screen>\r
-<screen><userinput>psql -U evergreen -h localhost -f Open-ILS/src/sql/Pg/reingest-1.6-2.0.sql evergreen</userinput></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
- . (If upgrading from 1.6.1.x, <filename>oils_web.xml</filename> should already exist.)</para>\r
- <indexterm><primary>configuration files</primary><secondary>oils_web.xml</secondary></indexterm>\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
- <caution><para>Copying these configuration files will remove any customizations you have made to them. Remember to redo your customizations after copying \r
- them.</para></caution>\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 \\r
---service all --create-offline --user evergreen --password evergreen \ \r
---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
- <caution>\r
- <para>Copying these Apache configuration files will remove any customizations you have made to them. Remember to redo your customizations after copying \r
- them. 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
- </caution> \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_Postgresqlto9.0">\r
- <title>Upgrading PostgreSQL from 8.4 to 9.0</title>\r
- <simplesect>\r
- <title>Upgrading PostgreSQL on Debian Squeez</title>\r
- <procedure>\r
- <step>\r
- <para>Stop Evergreen and disconnect clients from database.</para>\r
- </step> \r
- <step>\r
- <para>Add the following line to <filename>/etc/apt/sources.list</filename>:</para> \r
-<programlisting>\r
-deb http://www.backports.org/debian squeeze-backports main contrib non-free\r
-</programlisting>\r
- </step>\r
- <step>\r
- <para>Update the sources list on your server.</para>\r
-<screen><userinput> \r
-apt-get update\r
-</userinput></screen>\r
- </step>\r
- <step>\r
- <para>Backup your databases</para>\r
-<screen><userinput> \r
-$ pg_dump [db connect args] [db name] > evergreen-backup.sql\r
-</userinput></screen>\r
- </step>\r
- <step>\r
- <para>Install PostgreSQL 9.0 as well as the client, contrib and plperl support packages.</para>\r
-<screen><userinput> \r
-apt-get -t squeeze-backports install postgresql-9.0 postgresql-client-9.0 postgresql-contrib-9.0 postgresql-plperl-9.0\r
-</userinput></screen>\r
- </step>\r
- <step>\r
- <para>Drop the empty 9.0 cluster.</para>\r
-<screen><userinput> \r
-pg_dropcluster --stop 9.0 main\r
-</userinput></screen>\r
- </step>\r
- <step>\r
- <para>Update the 8.4 cluster (with evergreen database) to 9.0</para>\r
-<screen><userinput> \r
-pg_upgradecluster 8.4 main\r
-</userinput></screen>\r
- </step>\r
- <step>\r
- <para>Test by logging into psql, checking the postgrSQL version and running a simple SELECT query.</para>\r
-<screen><userinput> \r
-psql -U evergreen \r
-evergreen=# select version();\r
-evergreen=# select count(*) from biblio.record_entry;\r
-</userinput></screen>\r
- </step>\r
- <step>\r
- <para>Restart Evergreen and Apache.</para>\r
- </step>\r
- <step>\r
- <para>Drop old 8.4 cluster (optional).</para>\r
-<screen><userinput> \r
-pg_dropcluster 8.4 main\r
-</userinput></screen>\r
- </step>\r
- </procedure>\r
- </simplesect>\r
- <simplesect>\r
- <title>Upgrading PostgreSQL on Ubuntu 10.04</title>\r
- <procedure>\r
- <step>\r
- <para>Stop Evergreen and disconnect clients from database.</para>\r
- </step> \r
- <step>\r
- <para>Add the backport repository to your repository sources list:</para> \r
-<screen><userinput>\r
-sudo add-apt-repository ppa:pitti/postgresql\r
-</userinput></screen>\r
- </step>\r
- <step>\r
- <para>Update the sources list on your server.</para>\r
-<screen><userinput> \r
-apt-get update\r
-</userinput></screen>\r
- </step>\r
- <step>\r
- <para>As the <systemitem class="username">postgres</systemitem> user, backup your PostgreSQL databases.</para>\r
-<screen><userinput><![CDATA[ \r
-pg_dumpall > data\r
-]]></userinput></screen>\r
- </step>\r
- <step>\r
- <para>As <systemitem class="username">root</systemitem>, remove PostgreSQL 8.4 and install 9.0.</para>\r
-<screen><userinput> \r
-aptitude purge postgresql-8.4\r
-aptitude install postgresql-9.0 postgresql-client-9.0 postgresql-contrib-9.0 postgresql-plperl-9.0\r
-</userinput></screen>\r
- </step>\r
- <step>\r
- <para>as the <systemitem class="username">postgres</systemitem> user, recreate empty evergreen databases with required language supports.</para>\r
-<screen><userinput>\r
-dropdb evergreen\r
-createdb -T template0 --lc-ctype=C --lc-collate=C -E UNICODE evergreen\r
-createlang plperl evergreen\r
-createlang plperlu evergreen\r
-createlang plpgsql evergreen\r
-psql -f /usr/share/postgresql/9.0/contrib/tablefunc.sql evergreen\r
-psql -f /usr/share/postgresql/9.0/contrib/tsearch2.sql evergreen\r
-psql -f /usr/share/postgresql/9.0/contrib/pgxml.sql evergreen\r
-</userinput></screen>\r
- </step>\r
- <step>\r
- <para>Update the 8.4 cluster (with evergreen database) to 9.0.</para>\r
-<screen><userinput> \r
-pg_upgradecluster 8.4 main\r
-</userinput></screen>\r
- </step>\r
- <step>\r
- <para>as the <systemitem class="username">postgres</systemitem> user, load data from backup into PostgreSQL 9.0.</para>\r
-<screen><userinput><![CDATA[ \r
-psql < data\r
-]]></userinput></screen>\r
- </step>\r
- <step>\r
- <para>Restart Evergreen and Apache.</para>\r
- </step>\r
- <step>\r
- <para>Test by logging into psql, checking the postgrSQL version and running a simple SELECT query.</para>\r
-<screen><userinput> \r
-psql -U evergreen \r
-evergreen=# select version();\r
-evergreen=# select count(*) from biblio.record_entry;\r
-</userinput></screen>\r
- </step>\r
- </procedure>\r
- </simplesect>\r
- </section>\r
-</chapter>\r
projects / Evergreen-DocBook.git / blobdiff