This question has been flagged
1 Reply
3313 Views

I need to achieve the database backup at particular time everyday in version 7.0 ? Do anyone know how to proceed this?

Thanks in Advance !!

Avatar
Discard
Best Answer

If you work with a Linux server you should schedule your backup with cron

http://www.cyberciti.biz/faq/how-do-i-add-jobs-to-cron-under-linux-or-unix-oses/

the job you have to schedule is something like this:

sudo -u openerp pg_dump <name of="" the="" database=""> > backup_file.sql

Hope this helps

Avatar
Discard
Author

I found a link which was related to this question. http://help.openerp.com/question/8899/how-do-i-automate-database-backups/ I also tried the python script mentioned in the link, but it does'nt work

1) You could use http://www.postgresql.org/docs/9.0/static/continuous-archiving.html (Continuous Archiving) Postgres feature.

2) There is a the http://www.pgbarman.org/ (pgBarman project)