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
Adding this to the .conf file fixed the issue ...
db_template = template1
Hello,
For reference, you can also follow the Odoo Windows re-installation steps - https://webkul.com/blog/openerp-all-in-one-windows-cant-re-install-postgresql/
Hi,
This error happens on Windows when PostgreSQL is installed with mismatched collation and ctype settings, something Windows does not support. Odoo needs the database cluster to use the same LC_COLLATE and LC_CTYPE, but your PostgreSQL instance was initialized with different values, so Odoo cannot create or connect to the database. The solution is to reinstall or reinitialize PostgreSQL using matching locales—for example, reinstall PostgreSQL and allow it to use the default Windows locale (English_United States.1252 for both collate and ctype). Alternatively, you can manually drop and recreate the database using matching settings through pgAdmin or SQL: CREATE DATABASE odoo WITH TEMPLATE template0 LC_COLLATE='English_United States.1252' LC_CTYPE='English_United States.1252';. Once PostgreSQL has consistent collation settings, Odoo will connect and create databases normally.
For reference, you can also follow the Odoo Windows installation steps here: https://www.cybrosys.com/blog/how-to-install-odoo-17-in-windows
Hope it helps
Then after you can start Odoo by :-
python odoo-bin -d DB_NAME -i base
Create an account today to enjoy exclusive features and engage with our awesome community!
Sign up
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
I had the same problem, the same error message:
I uninstalled Postgresql 18 and installed Postgresql 16, now it's fine!