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/

Powiązane posty	Odpowiedzi	Widoki
psql command does not work psql	1 lut 24	1383
_sql_constraints fail to be effective Rozwiązane constraints psql	2 mar 24	5099
How to pass dynamic values in PSQL query CASE statement ? psql odoo11	1 lut 24	2414
why manual sequence does not work? sequence psql	0 sie 21	2320
It sounds to be a odoo bug in setting _sql_constraints constraints psql	0 sie 21	2387

To pytanie dostało ostrzeżenie

Podoba Ci się ta dyskusja? Dołącz do niej!