Cedeus DB backups
From stgo
>> return to Cedeus_IDE
How to set up Backups
copy of the geonode DB
- create a shell script that contains the pgdump instructions - see /home/ssteinig/geonode_backup.sh on CedeusDB
- test if script actually works (using sudo?)
- 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
- => in particular I changed "
local all postgres peer" to: "local all postgres md5"
- then add entry such as "
