Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
I'm setting up a development environment on Windows 10. I have installed GIT, PyCharm and PostgreSQL.
When I run Odoo and attempt to create the database I get this error ...
psycopg2.OperationalError: connection to server at "localhost" (::1), port 5432 failed: FATAL: collations with different collate and ctype values are not supported on this platform
Then after you can start Odoo by :-
python odoo-bin -d DB_NAME -i base
Adding this to the .conf file fixed the issue ...
db_template = template1
1. Use the live chat to ask your questions.
2. The operator answers within a few minutes.
Can you share the screenshot of this error and values of the database you entered.?
Here is the command to run odoo, followed by the log ...
(.venv) PS C:\Users\linco\Development\odoo> python odoo-bin -r odoo -w odoo --addons-path=C:\Users\linco\Development\odoo\addons -d odoo -i base
2025-11-27 08:17:33,876 7648 WARNING ? odoo.tools.config: missing --http-interface/http_interface, using 0.0.0.0 by default, will change to 127.0.0.1 in 20.0
2025-11-27 08:17:33,877 7648 INFO ? odoo: Odoo version 19.0
2025-11-27 08:17:33,877 7648 INFO ? odoo: Using configuration file at c:\users\linco\development\odoo\odoo.conf
2025-11-27 08:17:33,877 7648 INFO ? odoo: addons paths: _NamespacePath(['C:\\Users\\linco\\Development\\odoo\\odoo\\addons', 'C:\\Users\\linco\\AppData\\Local\\OpenERP S.A.\\Odoo\\addons\\19.0', 'c:\\users\\linco\\development\\odoo\\addons'])
2025-11-27 08:17:33,877 7648 INFO ? odoo: database: odoo@localhost:5432
2025-11-27 08:17:34,225 7648 INFO ? odoo.sql_db: Connection to the database failed
2025-11-27 08:17:34,225 7648 WARNING ? odoo.service.db: Unable to create PostgreSQL extensions : connection to server at "localhost" (::1), port 5432 failed: FATAL: collations with different collate and ctype values are not supported on this platform
Share the odoo.conf file here or you can match it with my conf
admin_passwd = Your Password
db_host = localhost
db_port = 5432
db_user = odoo
db_password = odoo
addons_path = Your Odoo Addons path
http_port = 1202
bin_path = C:\Program Files\wkhtmltopdf\bin
pg_path= C:\Program Files\PostgreSQL\14\bin