Skip to Content
Menu
This question has been flagged
6 Replies
7500 Views

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!

Avatar
Discard
Best Answer

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.

Avatar
Discard
Author

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).

Author

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

Best Answer

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
Avatar
Discard
Best Answer

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??

Avatar
Discard