Hello, I have an Odoo 8 installation on an Ubunut 14.04 VPS, it's working like a charm, however, I'm afraid one day something bad might happen!

So, I don't want to relay on manual backups done through odoo's interface; 8069/web/database/manager#action=database_manager , I want to make this automatic using cron, so far, I've tried pg_dump, I'm able to extract a database, however, I don't know how to restore it, I've tried creating a new one and populating it with the old database, however, odoo doesn't recognize and show it!

Can you please help me, I'd like two command lines I can run on my linux installation, one for backing up my Odoo db and one for restoring it.

Thanks so much.