You are hereOpenerp backups

Openerp backups


From cron I usually backup all database regularly, some ones daily, and delete backups older than 40 days.

0  4    * * 6   su postgres -c "export LANG=C; pg_dump -Fc --compress=9 --file=/var/backups/postgres/MYDB.$$  MYDB"
0  4    * * 6   su postgres -c "export LANG=C; pg_dump --clean --column-inserts --attribute-inserts --file=/var/backups/postgres/MYDB.$$  MYDB"
0  4    * * 6   su postgres -c "export LANG=C; pg_dumpall -o > /var/backups/postgres/all.$$";
0  6    * * 6   find /var/backups/postgres -xdev -ctime +40 -type f -exec rm \{\} \;

Then the server itself (and especially /var/backups /opt /etc) is backed up using backuppc (or a similar tool).

Tags