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"

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/