Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:

CRM
e-Commerce
Księgowość
Zapasy
PoS
Projekt
MRP

All apps

Wszystkie posty Osoby Odznaki

Tagi (Zobacz wszystko)

odoo accounting v14 pos v15

O tym forum

Pomoc

update on premise codebase or database

configuration setup

2 Odpowiedzi

114 Widoki

Hi,

We installed on-premise Odoo v19 community from source github and Enterprise from .deb package.

Question1 : can I always update codebase from github if I stay on v19 or v19.x github branche without update database ?

Question2: when need I update database and how to know if my codebase is compatible with current data se version ?

Question3: How can I track database version?

Cybrosys Techno Solutions Pvt.Ltd

Hi,

1- Simply pulling code from GitHub for your Odoo Community installation does not automatically update your database. For minor code changes like bug fixes or UI tweaks that don't alter data models, you can often restart Odoo without a database update. However, if the code changes involve modifications to database schemas (e.g., new fields, changed field types, new models), you must update the database by running Odoo with the -u flag (e.g., odoo-bin -u all). It's generally a best practice to perform a database update after any significant code pull, always testing in a staging environment first, and be mindful of potential compatibility issues if your Enterprise modules are from a separate .deb package and not updated in sync with your source-based Community code.

2- You need to update your database for major version upgrades, any schema changes within modules (like adding or modifying fields/models), data migrations, or after pulling significant code updates from GitHub. Incompatibility is often indicated by Odoo failing to start or throwing specific errors such as UndefinedColumn or UndefinedTable, which signal that the code expects a database structure different from what exists. Odoo internally tracks the version of each installed module, and running odoo-bin -u module_name compares these versions to apply necessary updates. Always test code and database updates in a staging environment before applying them to production.

3- Odoo does not maintain a single "database version" number; instead, it tracks the version of each individual installed module within the database. You can monitor these module versions through the Odoo user interface by navigating to Settings > Apps > Installed Apps and checking the "Version" column for each module. Alternatively, you can query the ir_module_module table in your PostgreSQL database, where the latest_version column for each module record indicates its current version in the database. When you run odoo-bin -u all, Odoo uses these stored versions to determine which modules require an update.

Hope it helps

Autor

1. Do you recommend me to install Enterprise from source too?
2. Where can i read more in Odoo-bin -u? Does this check Enterprise module too.
3. You Said if New model New fields… i need update database but instead read hundreds commit message how can I be awared easily if database is not compatible? I was thinking if we stay on v19 branch there is no New fields new model

CandidRoot Solutions

Hi Eb,

I hope you are doing good.

Please find answers to your questions below:

Q1: Can I update the codebase from GitHub (v19 / v19.x) without updating the database?

Yes, minor updates (bug fixes, small improvements) can usually be pulled from the v19.x branch without upgrading the database.
However, if the update includes new fields, models, or schema changes, then a database update will be required.

Q2: When do I need to update the database, and how do I know if the code is compatible?

You need to update the database when:
- Release notes mention database/schema changes
- You see errors like missing columns, models, or fields
Best practice:
- Always check GitHub commit messages / release notes
- Test updates first on a staging database
If Odoo starts normally and no migration errors appear, the code is compatible.

Q3: How can I track the database version?

You can check it in the following ways:

Enable Developer Mode → go to Settings → About
Or check the table ir_module_module for installed module versions
Also, the Odoo server log shows DB version during startup

Autor

When you say test on staging first, so i need duplicate my /opt/odoo and duplicate database ? If im on same instance ? And what about Enterprise licence I can have/run 2 Odoo with same licence code ?

Podoba Ci się ta dyskusja? Dołącz do niej!

Stwórz konto dzisiaj, aby cieszyć się ekskluzywnymi funkcjami i wchodzić w interakcje z naszą wspaniałą społecznością!

Zarejestruj się

Powiązane posty	Odpowiedzi	Widoki
What is the relationship between my odoo.com account / login and my test database account / login ? configuration setup	0 lis 25	428
Issue with CNAME Record & Custom Domain Configuration in Odoo configuration setup	3 lis 25	4168
email address change vendor invoices configuration setup	3 paź 25	3556
Linking DBs to sub-domains Rozwiązane configuration setup	1 wrz 25	1036
3-tier website account membership configuration setup	0 lip 25	1272

To pytanie dostało ostrzeżenie

Podoba Ci się ta dyskusja? Dołącz do niej!