Odoo Database Upgrade FAQ

4. Which database dump format is best suited for the upgrade?

You basically have 2 choices:

  • if you want a fast database dump and restore, choose the PostgreSQL tar-format compressed with gzip
  • if you want a small database dump file, choose the PostgreSQL tar-format compressed with xz

If you want to know how to dump/restore the format of your choosing, see question 5.