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!
Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
- 客户关系管理
- e-Commerce
- 会计
- 库存
- PoS
- Project
- MRP
此问题已终结
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 --config=<myconfig.conf>
).
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: -r openerp-test
.
thank you for your answer.It's inspiring~~!!! I have solved it...I am a freshman for openerp...
If this solved your question you can mark is as correct (just under the voting arrows).
additionally,you should change the code in /etc/postgresql/9.1/main/pg_hba.conf to # "local" is for Unix domain socket connections only the md5 --> trust
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
can you give me the codes for that, i am little bit confused about it. I was already installed odoo , is it possible to install the odoo again in different port??