How To Fix Odoo PostgreSQL UTF-8 Encoding


To fix this error, please run this following code

sudo -u postgres psql postgres

and then run this code

update pg_database set datallowconn = TRUE where datname = 'template0';
\c template0
update pg_database set datistemplate = FALSE where datname = 'template1';
drop database template1;
create database template1 with template = template0 encoding = 'UTF8';
update pg_database set datistemplate = TRUE where datname = 'template1';
\c template1
update pg_database set datallowconn = FALSE where datname = 'template0';

To exit from postgre console, please press Ctrl-D

Ref : Odoo Forum