Difference between revisions of "Cedeus DB backups"

From stgo
Jump to: navigation, search
(copy of the geonode DB)
(copy of the geonode DB)
Line 16: Line 16:
 
#:* check if postgres user has a password assigned already (use ALTER... to do so: http://wiki.geosteiniger.cl/mediawiki-1.22.7/index.php/Setting_up_geonode#Some_PostgreSQL_commands )
 
#:* check if postgres user has a password assigned already (use ALTER... to do so: http://wiki.geosteiniger.cl/mediawiki-1.22.7/index.php/Setting_up_geonode#Some_PostgreSQL_commands )
 
#:* create a .pgpass file to provide the password: http://wiki.postgresql.org/wiki/Pgpass
 
#:* create a .pgpass file to provide the password: http://wiki.postgresql.org/wiki/Pgpass
 +
# check also if the cron is running <code>sudo service cron status</code> otherwise start it...

Revision as of 14:53, 2 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

  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
  4. check also if the cron is running sudo service cron status otherwise start it...