Yes, this is possible. The basic is:
- Each instance should have its own user and home directory for security
- Each instance should be run on different ports
- Setup an HTTP proxy (Apache or NginX could be used) to proxy HTTP requests to the appropriate instance. E.g. xxx.company.com will be forwarded to openerpserver:8069 and yyy.company.com will be forwarded to openerpserver:8169
- Each instance should have its own PostgreSQL account for security reason.
Regarding "Each instance should have its own PostgreSQL account for security reason", I believe it is not enough and I even wonder if one shouldn't even have a separate Postgres server.
Actually, OpenERP postgres user is created as superuser (at leat by Odoo Windows installer). Thus, even with a dedicated user, each instance can access db instances of other users.
I realized that when I installed Odoo v8 which could list v7 db instances whereas it connects to PostgreSQL server with its own user (and it did not like instrospecting v7 db instances at all ...)
So, I uncheked 'superuser' option. From there, v8 instance could not list v7 databases. But, when restoring db dump, pg_restore complained it could not delete and recreate 'public' role ... which explains why db user is created as super user by default.
Hi Guys !!
We are an IT development company based in India, We are Gold partners with Oracle and are experts in ERP implementation.
We have also developed a Mini ERP to meet the needs of the SME's.
We get very good reviews for our services from our clients.
We can cater to any requirement in IT and that too in affordable prices.
Why should a modest budget mean you have to compromise on the quality of the services or products.
Do give us a call to discuss your needs and rest assured for the best services.
Sr. Business Development Manager
SRDT Pvt. Ltd.
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
|Asked: 4/1/13, 1:18 PM|
|Seen: 9226 times|
|Last updated: 6/17/16, 1:35 PM|