I'm using openERP v6.1 and I wanted to know which is the best alternative to make automated backups of the DB (let's say daily backups)
The Backup option in the web UI in Manage Databases it's great to restore and create the DB in one step. Of course it has to be done manually. Is there any way to automatize this process and get as results the same kind of backups? (I'm not sure what kind of file it exports as *.dump)
I tried doing pg_dump but I cannot import that file (I tried the raw sql text and gziped) from the web UI, of course must be different formats. And I have some issues trying to import a pg_dump backup to postgres with psql. I can restore the backup but then when access the site in the web, I saw an openERP empty
Any thoughts about best practices to do this?