update on premise codebase or database

configuration setup

2 Antwoorden

532 Weergaven

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?

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

Auteur

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 ?

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

Auteur

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

Geniet je van het gesprek? Blijf niet alleen lezen, doe ook mee!

Maak vandaag nog een account aan om te profiteren van exclusieve functies en deel uit te maken van onze geweldige community!

Aanmelden

Gerelateerde posts	Antwoorden	Weergaven
What is the relationship between my odoo.com account / login and my test database account / login ? configuration setup	0 nov. 25	620
Issue with CNAME Record & Custom Domain Configuration in Odoo Opgelost configuration setup	3 feb. 26	4540
email address change vendor invoices configuration setup	3 okt. 25	3815
Linking DBs to sub-domains Opgelost configuration setup	1 sep. 25	1158
3-tier website account membership configuration setup	0 jul. 25	1399

Deze vraag is gerapporteerd

Geniet je van het gesprek? Blijf niet alleen lezen, doe ook mee!