Changes between Version 5 and Version 6 of InstallationGuidelines/Linux/Server/CherokeePostgreSQL

Timestamp:

11/04/11 21:56:30 (13 years ago)

Author:

Fran Boon

Comment:

--

InstallationGuidelines/Linux/Server/CherokeePostgreSQL

@@ -324 +324 @@
 cat << EOF > "/usr/local/bin/backup"
 #!/bin/sh
+mkdir /var/backups/eden
+chown postgres /var/backups/eden
 NOW=\$(date +"%Y-%m-%d")
-su postgres
-pg_dump -c sahana > /root/backup-\$NOW.sql
-pg_dump -Fc gis > /root/gis.dmp
+su -c - postgres "pg_dump -c sahana > /var/backups/eden/sahana-\$NOW.sql"
+su -c - postgres "pg_dump -Fc gis > /var/backups/eden/gis.dmp"
 OLD=\$(date --date='7 day ago' +"%Y-%m-%d")
-rm -f /root/backup-\$OLD.sql
+rm -f /var/backups/eden/sahana-\$OLD.sql
 EOF
 chmod +x /usr/local/bin/backup