=== modified file 'src/docbkx/en/dhis2_implementation_guide_installation.xml'
--- src/docbkx/en/dhis2_implementation_guide_installation.xml 2012-11-19 11:33:05 +0000
+++ src/docbkx/en/dhis2_implementation_guide_installation.xml 2012-11-23 09:12:10 +0000
@@ -34,7 +34,7 @@
sudo update-alternatives --set java /usr/lib/jvm/java-7-openjdk/bin/java
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 ../java-7-openjdk-amd64/.. Check that your installation is okay by invoking java -version
Install PostgreSQL
- To install PostgreSQL version 9.2 we first need to add a Ubuntu package repository our system.
+ To install PostgreSQL version 9.2 we first need to add a Ubuntu package repository to our system.
sudo apt-get install python-software-properties
sudo add-apt-repository ppa:pitti/postgresql
sudo apt-get update
@@ -380,6 +380,18 @@
Working with the PostgreSQL database
+ Common operations when managing a DHIS instance are dumping and restoring databases. To
+ make a dump (copy) of your database, assuming the setup from the installation section, you can
+ invoke the following:
+ pg_dump dhis2 -U dhis -f dhis2.sql
+ The first argument (dhis2) refers to the name of the database. The second argument (dhis)
+ refers to the database user. The last argument (dhis2.sql) is the file name of the copy. If
+ you want to compress the file copy immediately you can do:
+ pg_dump dhis2 -U dhis | gzip > dhis2.sql.gz
+ To restore this copy on another system, you first need to create an empty database as
+ described in the installation section. You also need to gunzip the copy if you created a
+ compressed version. You can the invoke:
+ psql -d dhis2 -U dhis -f dhis2.sql
Using Amazon Web services