hey brothers. Can I ask a question to you : I want to set up two vertion oe in my ubuntu server. One for demo , and one for test. But I don't know how to configure the second oe. Can I have new a postgresql user for the second to solve the problem...And where can I change the 8069 port to other... I don't want to mix up my server, so I ask it first!
It's pretty straightforward to have multiple OpenERP servers running on the same machine. The trick is, as you already noticed, to have each one listening on a different port.
Using distinct listening ports
To set the port used by a server instance, start it with the option
--xmlrpc-port=<port>. This can also be done in the configuration file, if you are using one (i.e. starting the server with option
Using distinct database roles
There is no need to setup different Postgres instances ("clusters") for this. I would recommend you to use just one, and properly manage the different roles and databases inside it.
It's not required, but I find it to be a good practice to create a distinct role for each instance you'll be using. E.g:
sudo su -c "createuser --createdb --no-createrole --no-superuser openerp-test" postgres
And then, when starting the server add the option:
I also have two OpenERP server running on the same machine. I have the following setup:
- different locations for the OpenERP code. (e.g. /opt/openerpA, /opt/openerpB)
- separate PostgreSQL clusters (create a new with
pg_ctl -D /usr/local/pgsql/data <dbname>), the 2nd cluster also has another port (e.g. 5433)
- you then also have two PosgreSQL config dirs!
- for the 2nd OpenERP server you should also have a separate config-file
- Things to consider in the config: DB-connection parameters, change port to e.g. 8085
- separate start script for 2nd OpenERP server
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: 2/27/13, 11:36 PM|
|Seen: 2706 times|
|Last updated: 8/25/15, 6:31 AM|