=== 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