Backup/Restoring a Large Database using PSQL dump with Filestore?
I am using Odoo 11 CE
I tried to backup and restore by database by PSQL dump.
Step1 : Backup my database named rck_test5
sudo pg_dump -U rck10 -h localhost -p 5432 rck_test5 > /odoo/backups/new
Step2: Created new db
createdb -O rck10 rck_test6
Step3: Restore the database
psql -U rck10 -d rck_test6 -f /odoo/backups/new
Everything works fine. But when restored, I am missing all icons and images attached.
I found that these files are stored in ./local/share/Odoo/filestore/dbname when we create or restore database from ui.
When we restore using UI, filestore is zipped and restored properly.
But when we want to restore a database that is more than 10 GB, it is adviced to use psql dump.
I tried setting data_dir path in odoo-server.conf. But it does not generate filestore.
I need to know how to backup and restore filestore using command line. (Reason : I get to see full log of what is happening when we restore a huge database)
Please guide how to
* Backup a filestore
* Restore a filestore
* Update path in ir_attachement.location
to set odoo to read the new filestore location. Please guide me