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/

المنشورات ذات الصلة	الردود	أدوات العرض
psql command does not work psql	1 فبراير 24	1374
_sql_constraints fail to be effective تم الحل constraints psql	2 مارس 24	5088
How to pass dynamic values in PSQL query CASE statement ? psql odoo11	1 فبراير 24	2403
why manual sequence does not work? sequence psql	0 أغسطس 21	2317
It sounds to be a odoo bug in setting _sql_constraints constraints psql	0 أغسطس 21	2382

لقد تم الإبلاغ عن هذا السؤال

هل أعجبك النقاش؟ لا تكن مستمعاً فقط. شاركنا!