Cedeus DB backups

>> return to Cedeus_IDE

---

How to set up Backups

copy of the geonode DB

1. create a shell script that contains the pgdump instructions - see /home/ssteinig/geonode_backup.sh on CedeusDB
2. test if script actually works (using sudo?)
3. create a cron-tab entry for admin/root user using "crontab -e"

   then add entry such as "00 01 * * * /home/ssteinig/geonode_backup.sh" to run the script daily at 1:00 am

   => when using the user "postgres" then pg_hba.conf file needs to adjusted to trust local connections. See:

   • http://stackoverflow.com/questions/15359348/run-batch-file-with-psql-command-without-password and
   • http://help.ubuntu.com/10.04/serverguide/postgresql.html

   => in particular I changed "local all postgres peer" to: "local all postgres md5"