Odoo Database Upgrade FAQ

6. Which options to choose when dumping a database?

Beside the --format which we already covered in the previous section, you can probably use the -O and the -x options.

  • -O option means no owner information will be dumped. The upgrade platform does not use that information and is not configured with the same users than in your own Postgresql server. The owners of your database objects are skipped when we upgrade your database and the upgraded database you will receive will not contains any owner information since we also use the same option when dumping the upgraded database.
  • -x option means no access privileges will be dumped. For the same reasons than we already described about the -O option, we don't restore your database with access privileges and we don't dump these access privileges when creating the upgraded dump.

There are options that you should absolutely avoid when creating your dump.

  • -c (or --clean): automatic restoration will fail at our end and your request will be considered invalid
  • -C (or --create): automatic restoration will fail at our end and your request will be considered invalid
  • -a (or --data-only): for obvious reasons, we need the data ;)
  • -s (or --schema-only): for obvious reasons, we need the schema ;)
  • --column-inserts, --attribute-inserts, --inserts: will make the restoration process very slow

In case you are wondering if you can use an option, please ask the Upgrade Team.