how to solve error "psycopg2.ProgrammingError: relation "base_registry_signaling" already exists - - " in odoo14?

Question

I got this error after restored the database. I granted all privileges to the database using certain psql commands. Now, I messed up with an error "psycopg2.ProgrammingError: relation "base_registry_signaling" already exists - - ".

Could anyone please help me to solve this!

Answer 1

This error means Odoo is trying to create a new database, but it can't because the database already exists. Odoo probably doesn't have access rights to your database.

The owner of database must be the same as the db_user that you added in the Odoo configuration file.