dhis2-devs team mailing list archive

[noreply@xxxxxxxxxxxxx]

------------------------------------------------------------
revno: 629
committer: Lars Helge Øverland <larshelge@xxxxxxxxx>
branch nick: dhis2-docbook-docs
timestamp: Mon 2012-11-19 12:33:05 +0100
message:
  Postgres 9.2 install
modified:
  src/docbkx/en/dhis2_implementation_guide_installation.xml


--
lp:~dhis2-documenters/dhis2/dhis2-docbook-docs
https://code.launchpad.net/~dhis2-documenters/dhis2/dhis2-docbook-docs

Your team DHIS 2 developers is subscribed to branch lp:~dhis2-documenters/dhis2/dhis2-docbook-docs.
To unsubscribe from this branch go to https://code.launchpad.net/~dhis2-documenters/dhis2/dhis2-docbook-docs/+edit-subscription

=== modified file 'src/docbkx/en/dhis2_implementation_guide_installation.xml'
--- src/docbkx/en/dhis2_implementation_guide_installation.xml	2012-11-19 10:48:31 +0000
+++ src/docbkx/en/dhis2_implementation_guide_installation.xml	2012-11-19 11:33:05 +0000
@@ -34,14 +34,19 @@
 sudo update-alternatives --set java /usr/lib/jvm/java-7-openjdk/bin/java</screen>
     <para>Please check that the path the Java binaries are correct as they might vary from system to system, e.g. on AMD systems you might see <emphasis role="italic">../java-7-openjdk-amd64/..</emphasis> Check that your installation is okay by invoking <code>java -version</code></para>
     <para><emphasis role="bold">Install PostgreSQL</emphasis></para>
-    <para>Install PostgreSQL by invoking <code>sudo apt-get install postgresql-9.1</code></para>
+    <para>To install PostgreSQL version 9.2 we first need to add a Ubuntu package repository our system.</para>
+    <para><code>sudo apt-get install python-software-properties
+sudo add-apt-repository ppa:pitti/postgresql 
+sudo apt-get update
+    </code></para>    
+    <para>Now install PostgreSQL by invoking <code>sudo apt-get install postgresql-9.2</code></para>
     <para>Switch to the postgres user by invoking <code>sudo su postgres</code>.</para>
     <para>Create a non-privileged user called <emphasis role="italic">dhis</emphasis> by invoking
         <code>createuser -SDRP dhis</code>. Enter a secure password at the prompt. Create a database by invoking
         <code>createdb -O dhis dhis2</code>.  Return to your session by invoking <code>exit</code> You now have a
       PostgreSQL user called <emphasis role="italic">dhis</emphasis> and a database called <emphasis role="italic">dhis2</emphasis>.</para>
     <para>Do performance tuning by opening the following  file by invoking </para>
-    <para><code>sudo nano /etc/postgresql/9.1/main/postgresql.conf</code></para>
+    <para><code>sudo nano /etc/postgresql/9.2/main/postgresql.conf</code></para>
     <para>and set the following properties:</para>
     <para><code>shared_buffers = 512MB</code></para>
     <para>Determines how much memory PostgreSQL can use for caching of query data. Is set too low by default since it depends on kernel shared memory which is low on some operating systems.</para>