Odoo 12 Development Essentials - Fourth Edition

Creating a staging environment

If you have followed the approach described in the Installing from the source code section correctly, you should now be able to fetch and test new versions of source code in the staging repository. It's strongly advised that you make a copy of the production database and test any upgrades on it. If odoo-prod is your production database, an odoo-stage copy can be created with the following commands:

$ dropdb odoo-stage$ createdb --owner=odoo odoo-stage
$ pg_dump odoo-prod | psql -d odoo-stage
$ sudo su odoo
$ cd ~/.local/share/Odoo/filestore/
$ cp -al odoo-prod odoo-stage  # create filestore hardlinks$ exit

Before we can use the preceding copy of the database, cleanup should be done, such as deactivating scheduled ...