Odoo Help

2

2
5 Answers
12
Avatar

Ivan Elizaryev

--Ivan Elizaryev--
805
| 4 3 9
Ufa, Russian Federation
--Ivan Elizaryev--

I tried odoo at the end of 2013. I fell in love in it and have been working with odoo as a freelancer for almost two years. In September 2015 I began operate as a Company and have 5 developers for now.

Ivan, March 2016.

Ivan Elizaryev
9/19/14, 12:46 AM

I copy-paste solution from Tauras link.

 

In console run psql:

sudo -u postgres psql postgres

then in psql console execute sequence of commands:

 

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';

(press Ctrl-D to quit from psql)

 

 

1 Comment
sengottuvel
1/18/16, 12:18 AM

Thanks it's worked for me.

2
Tauras Paliulis
5/19/14, 7:57 AM

Check this out. It helped me http://www.openerp.bg/%D0%B1%D0%BB%D0%BE%D0%B3/item/163-%D0%BF%D1%80%D0%BE%D0%BC%D1%8F%D0%BD%D0%B0-%D0%BD%D0%B0-postgresql-default-template0-%D0%BD%D0%B0-utf8-encoding

1 Comment
Mustufa Rangwala
11/10/17, 8:26 AM

Above blog worked for me. Thank Tauras.

0

Check the following PR to documentation for odoo:

https://github.com/odoo/odoo/pull/18145/files

0

Hi,

Thanks for the post this solution.

But, what's the origin of this problem?

I've reviewed into odoo code and they use postgresql template1 for createdb porpuse.

Then, is it a bug of odoo? or is a misconfiguration introduced by system's locale? or is a postgresql default configuration?

I'll appreciate your response.

-Joaquin

Ask a Question
Writer
Tag
Keep Informed
1 follower(s)
About This Community

This platform is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.

Register
Odoo Training Center

Access to our eLearning platform and experience all Odoo Apps through learning videos, use cases and quizzes.

Test it now