psql error

Question

Database creation error: encoding "UTF8" does not match locale "en_US" DETAIL: The chosen LC_CTYPE setting requires encoding "LATIN1".
i'm facing the problem   when  create database using odoo13
it works fine with odoo10

Hisham Osama · Answer

1- Uninstall postgres using:
sudo apt-get --purge remove postgresql postgresql-*
dpkg -l | grep postgres
sudo apt-get --purge remove postgresql postgresql-doc postgresql-common
2- change locales/rebooted before running salt
sudo update-locale LANG=en_US.utf8
sudo update-locale LANGUAGE=en_US.utf8
reboot
3- reinstall sql and create user using:
sudo apt install postgresql

sudo su - postgres -c "createuser -s odoo"

Paresh Wagh · Answer

Hi Mostafa:
Looks like the system locale has not been configured for UTF-8. The following link provides instructions on how to configure the system locale on Debian 9. You will need to do something similar based on the operating system of your server.
https://www.rosehosting.com/blog/configure-system-locale-on-debian-9/ [1]

[1] https://www.rosehosting.com/blog/configure-system-locale-on-debian-9/

Related Posts	Odpovědi	Zobrazení
psql command does not work psql	1 úno 24	2810
_sql_constraints fail to be effective Vyřešeno constraints psql	2 bře 24	7365
How to pass dynamic values in PSQL query CASE statement ? psql odoo11	1 úno 24	3977
why manual sequence does not work? sequence psql	0 srp 21	3583
It sounds to be a odoo bug in setting _sql_constraints constraints psql	0 srp 21	3841

This question has been flagged

Enjoying the discussion? Don't just read, join in!