How to restore and backup db, all collaterals, and restore via script to fresh server?
I am trying to perform a backup-and-restore on a test Odoo installation (currently working with v8), without much success. I want to be able to achieve this workflow:
Take a backup of the entire deployment (single standalone instance)
Install Odoo on a new server / erase Odoo from current server and re-install fresh
Restore the backup file to the new instance using an automation script (Linux, bash)
How to reliably take a full backup of the database, such that in one operation (or multiple, scriptable via bash), I can restore the database, additional file assets, and installed modules to a new server?
I have tried two tacks, neither of which work/fulfil my requirements
A/ Manage Databases
Using the Manage Databases interface, I create a backup of the instance which gives me a backup file --> OK
Then on the new instance I upload the database via the web interface. This does not restore some information, notably the logo file. I suspect it does not add modules either, and it is not automatable in this manner.
What might I have missed, and how would I achieve this on the command line?
I guess the filestore in /var/lib/odoo/.local/share/Odoo/filestore/odoo_test would be relevant, but I looked for a file that matched the image and did not find it
B/ Raw database dump / restore
Using psql I dumped the odoo_test database I had set up
Then on the new instance (no initial setup had been done - going to the web interface prompts me to install fresh) I use psql to restore the same database.
When visiting the web interface again, it still is not aware of the instance - obviously, I would likely need to configure its existence somewhere
I looked for a file corresponding to my odoo_test database, but could not locate any
root@bas-test:/usr/lib/python2.7/dist-packages/openerp# grep -irl odoo_test
# yielded nothing
Thank you for any suggestion, pointers