Odoo is the world's easiest all-in-one management software. It includes hundreds of business apps:
CRM | e-Commerce | Accounting | Inventory | PoS | Project management | MRP | etc.
I just tested a migration of 6.1 to 7 (just the software, not data); and I noticed that the Ubuntu dependencies installed PostgreSQL 9.1, instead of reusing existing 8.4.
Does version 7 really require PostgreSQL 9.1, or what is the reason for such dependency? I have read some posts about performance benefits of using 9.x, but none about functional requirements (like OpenERP using something that is only available in 9.x PostgreSQL versions).
I am mainly asking because, if there is no functional dependency, I would rather keep my PostgreSQL 8.4 for the moment (unsure how to do it, if the packages have the dependency; but I would not mind giving it a try if that is a valid combination).
I think my question would be solved if we had a compatibility matrix between OpenERP and PostgreSQL; actually, other companies use those matrices to "certify" what versions of the RDBMS works fine with each release of the product. Do we have something like that for OpenERP? If not, it may be a good idea to consider ;-|
Thanks in advance.
The policy at Odoo SA is to develop new versions of Odoo using the current Debian Stable release of the day. That dictates the version of PostgreSQL that is required.
That said, it MAY - or may not - work with previous versions of PostgreSQL. It MAY - and quite probably will - work with later PostgreSQL versions.
The only thing you can count on is : it WILL work with the version that is recommanded - bug appart of course.
You could just grab the source code http://nightly.openerp.com/7.0/nightly/src/openerp-7.0-latest.tar.gz and connect it to PostgreSQL 8.4.
Personally we're running 9.2. I wouldn't set up a new server with anything prior to 9.x, current query listings are really handy IMO.
Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!
About This Community
This platform is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.Register
Odoo Training Center
Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.Test it now
|Asked: 4/8/14, 3:49 AM|
|Seen: 1464 times|
|Last updated: 3/16/15, 8:10 AM|