Difference between revisions of "Cedeus DB backups"
From stgo
(→How to set up Backups) |
m (→How to set up Backups) |
||
| Line 7: | Line 7: | ||
# 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?) | ||
| − | # create a cron-tab entry for admin/root user using <code>crontab -e</code> | + | # create a cron-tab entry for admin/root user using "<code>crontab -e</code>" |
| − | #: then add entry such as <code>00 01 * * * /home/ssteinig/geonode_backup.sh</code> to run the script daily at 1:00 am | + | #: then add entry such as "<code>00 01 * * * /home/ssteinig/geonode_backup.sh</code>" 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 | #: => 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 <code>local all postgres peer</code> to: <code>local all postgres md5</code> | + | #: => in particular I changed "<code>local all postgres peer</code>" to: "<code>local all postgres md5</code>" |
Revision as of 17:45, 1 December 2014
>> 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 "
