=== added directory 'resources/cron'
=== added file 'resources/cron/pg_backup.cron'
--- resources/cron/pg_backup.cron	1970-01-01 00:00:00 +0000
+++ resources/cron/pg_backup.cron	2011-06-13 12:02:17 +0000
@@ -0,0 +1,1 @@
+0 23 * * * /usr/local/bin/pg_backup.sh

=== added file 'resources/cron/pg_backup.sh'
--- resources/cron/pg_backup.sh	1970-01-01 00:00:00 +0000
+++ resources/cron/pg_backup.sh	2011-06-13 12:02:17 +0000
@@ -0,0 +1,18 @@
+#!/bin/sh
+
+# The backupdir must be created manually (mkdir pg_backups)
+# The backupdir owner must be changed to postgres (chown postgres pg_backups)
+# Script must be made executable (chmod 755 pg_backup.sh)
+# Script must be invoked by postgres user
+
+backup_dir="/var/backups/pg_backups"
+datetime=`date +%F`
+backupfile="$backup_dir/pg-backup-$datetime.gz"
+
+echo "Starting backup..."
+
+/usr/bin/pg_dump dhis2ke -U postgres | gzip > $backupfile
+
+timeinfo=`date '+%T %x'`
+
+echo "Backup file $backupfile complete at $timeinfo"