Odoo setup, postgreSQL database creation issue

For those who tried to setup Odoo (ex openERP) with a postgreSQL database, we might face a problem when running using the web setup for the first time.

The error I got was

Fixing this isn’t that hard but you need access to the database server to make some fixes to the template0 or template1 schema (see link mentioned below).

I don’t see the point to copy / paste other blog content, just follow the instructions mentioned in the link below and you’re done.

Enjoy !

Inspired by
https://techjourney.net/convert-postgresql-template0-template1-encoding-to-utf8-sql_ascii-incompatible/

More resources

PostgreSQL documentation: Template Databases
https://www.postgresql.org/docs/9.0/static/manage-ag-templatedbs.html

Leave a Reply

Your email address will not be published. Required fields are marked *



Back to Top