Difference between revisions of "Cedeus DB backups"
From stgo
(→How to set up Backups) |
(→How to set up Backups) |
||
| Line 4: | Line 4: | ||
== How to set up Backups == | == How to set up Backups == | ||
| − | copy of the geonode DB | + | === notifications === |
| + | To get notified about the backups via email, a/the shell script may send emails via "mailx" - i.e Nail. | ||
| + | => see http://klenwell.com/press/2009/03/ubuntu-email-with-nail/ | ||
| + | |||
| + | === copy of the geonode DB === | ||
# create a shell script that contains the pgdump instructions - see /home/ssteinig/geonode_backup.sh on CedeusDB | # create a shell script that contains the pgdump instructions - see /home/ssteinig/geonode_backup.sh on CedeusDB | ||
# test if script actually works (using sudo?) | # test if script actually works (using sudo?) | ||
Revision as of 18:15, 1 December 2014
>> return to Cedeus_IDE
How to set up Backups
notifications
To get notified about the backups via email, a/the shell script may send emails via "mailx" - i.e Nail. => see http://klenwell.com/press/2009/03/ubuntu-email-with-nail/
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:
- => in particular I changed "
local all postgres peer" to: "local all postgres md5"
- then add entry such as "
