From 52cfea629b7625aaa85eca0c1187d5a7e17fd501 Mon Sep 17 00:00:00 2001 From: Robert Soulliere Date: Fri, 10 Sep 2010 15:53:26 -0400 Subject: [PATCH] Add upgrading postgresql to 8.3. Add a few chapters top root Edit docbook conversion script to point to github working directory. --- 1.6/admin/Upgrading-Evergreen_1.6.xml | 50 +++++++++++++++++++++++++-- 1.6/appendices/temp.xml | 0 1.6/root.xml | 3 ++ tools/docbookConvert.sh | 6 ++-- 4 files changed, 54 insertions(+), 5 deletions(-) delete mode 100644 1.6/appendices/temp.xml diff --git a/1.6/admin/Upgrading-Evergreen_1.6.xml b/1.6/admin/Upgrading-Evergreen_1.6.xml index aa7807e7c8..f24bfcb661 100644 --- a/1.6/admin/Upgrading-Evergreen_1.6.xml +++ b/1.6/admin/Upgrading-Evergreen_1.6.xml @@ -259,8 +259,8 @@ - - Restart Evergreen and Test + + Restart Evergreen and Test As the opensrf user, start all @@ -291,4 +291,50 @@ section of this documentation for tips on finding solutions and seeking further assistance from the Evergreen community. + + Upgrading PostgreSQL from 8.2 to 8.3 + Evergreen 1.6 supports PostgreSQL version 8.3 and it is recommended that you upgrade PostgreSQL when you upgrade Evergreen to 1.6. + The Order of the following steps is very important. + + + As opensrf, stop the evergreen and opensrf services: + osrf_ctl.sh -l -a stop_all + + + Backup the Evergreen database data + + + Create an empty Evergreen database in postgresql 8.3 by issuing the following commands as the postgres user: + createdb -E UNICODE evergreen + createlang plperl evergreen + createlang plperlu evergreen + createlang plpgsql evergreen + psql -f /usr/share/postgresql/8.3/contrib/tablefunc.sql evergreen + psql -f /usr/share/postgresql/8.3/contrib/tsearch2.sql evergreen + psql -f /usr/share/postgresql/8.3/contrib/pgxml.sql evergreen + + + As the postgres user on the PostgreSQL server, create a PostgreSQL user named evergreen for the database cluster: + createuser -P -s evergreen + Enter the password for the new PostgreSQL superuser (evergreen) + + + Restore data from backup created in step 1. + + + To point tsearch2 to proper function names in 8.3, run the SQL script + /home/opensrf/Evergreen-ILS*/Open-ILS/src/sql/Pg/000.english.pg83.fts-config.sql using the psql command. + + + Restart Evergreen and OpenSRF services + + + For additional information regarding upgrading PostgreSQL, see the following documentation in PostgreSQL: + + + + + + + diff --git a/1.6/appendices/temp.xml b/1.6/appendices/temp.xml deleted file mode 100644 index e69de29bb2..0000000000 diff --git a/1.6/root.xml b/1.6/root.xml index 638207e9f8..59cee76b99 100755 --- a/1.6/root.xml +++ b/1.6/root.xml @@ -68,9 +68,12 @@ + + + diff --git a/tools/docbookConvert.sh b/tools/docbookConvert.sh index 51b5f914d7..0553ff0097 100755 --- a/tools/docbookConvert.sh +++ b/tools/docbookConvert.sh @@ -1,14 +1,14 @@ #/bin/bash #generate draft html - xsltproc --xinclude --stringparam base.dir /openils/var/web/evergreen_documentation/draft/html/ /home/rsoulliere/doctools/EvergreenDocumentation/evergreen_docbook_files/evergreen_xhtml.xsl /home/rsoulliere/doctools/EvergreenDocumentation/root.xml + xsltproc --xinclude --stringparam base.dir /openils/var/web/evergreen_documentation/draft/html/ ~/Evergreen-DocBook/stylesheets/evergreen_docbook_files/evergreen_xhtml.xsl ~/Evergreen-DocBook/1.6/root.xml #Generate PDF via FO -xsltproc --xinclude --output /home/rsoulliere/doctools/EvergreenDocumentation/pdf/temp.fo /home/rsoulliere/doctools/EvergreenDocumentation/evergreen_docbook_files/evergreen_fo.xsl /home/rsoulliere/doctools/EvergreenDocumentation/root.xml + xsltproc --xinclude --output ~/Evergreen-DocBook/1.6/pdf/temp.fo ~/Evergreen-DocBook/stylesheets/evergreen_docbook_files/evergreen_fo.xsl ~/Evergreen-DocBook/1.6/root.xml # must run fop from same directory as root.xml -cd /home/rsoulliere/doctools/EvergreenDocumentation/ +cd ~/Evergreen-DocBook/1.6/ ~/doctools/fop/fop -fo pdf/temp.fo -pdf /openils/var/web/evergreen_documentation/draft/pdf/Evergreen_Documentation.pdf -- 2.43.2