OpenERP

OpenERP Server and PostgreSQL Database

Asked by Rama Chavali

I work for a small manufacturing company in mac environment and have many application on virtual machines. I current have openerp 4 with postgresql database on a ubuntu VM. I am trying to make it so separate the database from the server and web application by having postgresql on mac os x (which is working currently) and have the OpenERP 5 server and web client run from a ubuntu vm. Is this possible and how can this be achieved? If you have any information that can help me find the solution, please contact me at <email address hidden>

Question information

Language:
English Edit question
Status:
Answered
For:
OpenERP Edit question
Assignee:
No assignee Edit question
Last query:
Last reply:
Revision history for this message
Mantavya Gajjar (Open ERP) (mga) said : 		#1

Well this is possible that we will make all machines separately for one for each application
in your case you would like to keep the PostrgeSQL septate from the Web Client and Server Application which is hosted to the Virtual machines on VMWare

First of all you have to configure the PostgreSQL to allow connection from other host which is allow by default to the localhost only
Look here to configure the postgres
http://www.postgresql.org/docs/8.2/static/auth-pg-hba-conf.html
http://developer.postgresql.org/pgdocs/postgres/auth-pg-hba-conf.html

Then Run the Server with following option

  Database related options:
    -d DB_NAME, --database=DB_NAME
                        specify the database name
    -r DB_USER, --db_user=DB_USER
                        specify the database user name
    -w DB_PASSWORD, --db_password=DB_PASSWORD
                        specify the database password
    --pg_path=PG_PATH specify the pg executable path
    --db_host=DB_HOST specify the database host
    --db_port=DB_PORT specify the database port
    --db_maxconn=DB_MAXCONN

Where ths important options are `--db_host` and `--db_port`

Can you help with this problem?

Provide an answer of your own, or ask Rama Chavali for more information if necessary.

To post a message you must log in.