odoo db restore permissions [SOLVED]
Recently i’ve incurred in some permissions problem restoring a database dump.
Specifically they was:
- psycopg2.errors.InsufficientPrivilege: permission denied for relation
- psycopg2.errors.DuplicateTable
I’ve solved simply running a query on database with:
GRANT postgres TO <user>;
Thanks to this thread on stackoverflow:
https://stackoverflow.com/questions/62472371/psycopg2-errors-insufficientprivilege-permission-denied-for-relation-django-mig