"UndefinedFunction: function unaccent_schema.unaccent(unknown, text) does not exist" while run any restored database in odoo

Question

I am able to run local database, but in the case of restored database I get below error:

odoo.addons.base.models.ir_qweb.QWebException: Error while render the template
UndefinedFunction: function unaccent_schema.unaccent(unknown, text) does not exist
LINE 2:                 SELECT unaccent_schema.unaccent('unaccent_sc...
                               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
QUERY:  
                SELECT unaccent_schema.unaccent('unaccent_schema.unaccent', $1)
                
CONTEXT:  SQL function "unaccent" during inlining

Template: web.frontend_layout

I have created the extension unaccent in my postgres but it's not working. I have executed many other commands but no luck at all.

Answer 1

The addition module unaccent needs to be installed once per database. Not "in my postgres", in particular not in the default maintenance database called "postgres", but in the actual database you are working with:

CREATE EXTENSION unaccent;

Related:

• Does PostgreSQL support "accent insensitive" collations?
• How to use (install) dblink in PostgreSQL?

Basics about Database clusters and databases in the manual chapter "Managing Databases".