Visual Basic Online Courses DataGridView CRUD SQL Server

Read the previous [Part1] 

Odoo 19 Portable on USB + PostgreSQL (C Collation) — Windows 11 Home (Single Language)

🧩 Extension: PowerShell Commands, Configuration Notes & Final Adjustments

This section extends the original guide by adding the exact logic and workflow we used during the setup of the portable Odoo 19 Development Environment on a USB drive, along with PostgreSQL 18.1 on Windows 11 Home Single Language. It includes placeholders for screenshots, code examples, and additional technical notes you requested.

📌 Preparing the USB Portable Environment (Additional Notes)

During the setup, we validated drive performance using built-in Windows tools before installing Odoo. You may insert screenshots here to illustrate each step:

We also confirmed that the USB stick supports sustained read/write speeds suitable for Python and Odoo module loading. Although USB 3.0 is recommended, the solution still works flawlessly on modern USB 2.0 sticks—just a bit slower.

⚙️ PostgreSQL 18.1 Installation with C Collation (Extended Explanation)

Windows 11 Home Single Language forces a system locale that may lead to the PostgreSQL collation mismatch error. We solved this by explicitly creating a database with the C COLLATION to avoid Unicode normalization inconsistency.

Below is a PowerShell snippet you can place as a code block when creating your database manually:

# Create Odoo Database with C collation
createdb -U postgres -E UTF8 --lc-collate=C --lc-ctype=C odoo19db

This ensures Odoo will operate without raising collation inconsistencies when loading modules, executing ORM queries, and installing third-party apps.

🛠️ Additional PowerShell Automation (Optional Script)

If you want to automate environment setup on different machines, you can insert a PowerShell script like the following:

# Auto-start PostgreSQL and Odoo from USB portable environment
Start-Process "D:\PortableOdoo\postgres\bin\pg_ctl.exe" -ArgumentList "start -D D:\PortableOdoo\data" 

Start-Process "D:\PortableOdoo\python\python.exe" -ArgumentList "D:\PortableOdoo\odoo\odoo-bin -c D:\PortableOdoo\odoo\odoo.conf"

Replace D:\PortableOdoo with the actual USB root folder you are using. The script ensures PostgreSQL starts before Odoo automatically.

🔧 Extended Odoo Configuration Notes

Here is a more detailed look into the odoo.conf additions for portable deployments:

[options]
addons_path = D:\PortableOdoo\odoo\addons
data_dir = D:\PortableOdoo\odoo-data
logfile = D:\PortableOdoo\odoo.log
db_host = localhost
db_port = 5432
db_user = postgres
db_password = yourpasswor
proxy_mode = True

If you include screenshots showing where to place the configuration file inside your USB directory structure, the guide will become even clearer for readers.

🎥 Watch the Full Video Tutorial

I recorded the entire setup process step by step—including the PostgreSQL installation, the collation fix, and the portable Odoo19 startup sequence. You can watch it here:

👉 Click here to watch the full tutorial on YouTube

If the video helps you, consider liking the video, subscribing to the channel, and leaving a comment with your questions or ideas. This directly supports free content like this tutorial series.