Skip to Content
This question has been flagged
4 Replies
641 Views
Avatar
Lincoln Eddy

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


 

Avatar
Discard
Codesphere Tech

Can you share the screenshot of this error and values of the database you entered.?

Lincoln Eddy
Author

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

Codesphere Tech

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

Kurt Maurer

I had the same problem, the same error message:

I uninstalled Postgresql 18 and installed Postgresql 16, now it's fine!

Avatar
Lincoln Eddy
Author Best Answer

Adding this to the .conf file fixed the issue ... 

db_template = template1
Avatar
Discard
Avatar
Kuldeep Singh
Best Answer

Hello, 

This error happens on Windows when PostgreSQL is installed with a database collation that does not match the system locale expected by Odoo. On Windows, PostgreSQL is strict about LC_COLLATE and LC_CTYPE values, and Odoo requires both to be the same while creating a new database.

If PostgreSQL was installed using a different locale (for example, default Windows collation) and Odoo tries to create a database with C or en_US, this conflict occurs. To fix this, reinstall PostgreSQL and choose a locale like English_United States for both collation and character type, or manually create the database with matching LC_COLLATE and LC_CTYPE values.

After aligning the locale settings, restart PostgreSQL and run Odoo again to create the database successfully.


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/

Avatar
Discard
Avatar
Cybrosys Techno Solutions Pvt.Ltd
Best Answer

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


Avatar
Discard
Avatar
Mr. Rana
Best Answer
Here, you can set basic conf for odoo.conf

db_host = localhost
db_port = 5432
db_user = postgres
db_password = yourpassword
addons_path = C:\Users\linco\Development\odoo\addons

After that,

Check your python version by :-
​python --version
(Because for Odoo 19.0, python3.12 is suitable)

Activate the Python virtual environment and run below :-
​pip install -r requirements.txt


Then after you can start Odoo by :-
​python odoo-bin -d DB_NAME -i base

Avatar
Discard