How to connect Odoo with postgres (which is running on other server)
If I am not mistaken, you must change the user in the database, odoo
doesn't allow "postgres" as the user, you must create an "odoo user" to connect the application to the database like this:
db_user: odoo
db_password: yourpassword
Then in the postgres.conf
file you must change this line:
listen_adresses = 'localhost'
I can't remember if something must be changed in the .hba
![Sai Teja Chowderpally](https://lh6.googleusercontent.com/-PCfLOKMbOsk/AAAAAAAAAAI/AAAAAAAAWa0/ij4tggcBOlQ/photo.jpg?sz=256)
Sai Teja Chowderpally
Updated on June 09, 2022Comments
-
Sai Teja Chowderpally about 2 years
I want to connect odoo 10 with the postgresql (which is running on other server). Is it possible ? If, yes! then please do help me out by posting step by step procedure or any sort of tutorial link (because I'm beginner). For now, I'm using odoo10 and postgresql-9.6 For different servers I'm using two different virtual machines (one is for odoo & other is for postgresql)
Here, I'm using two virtual machines 216.200.116.8 (for odoo) & 216.200.116.174 (for postgresql). I'm able to access postgresql from 216.200.116.8 remotely.
Here is my /etc/odoo.conf
Here is my /etc/postgresql/9.6/main/postgresql.conf
Here is my /etc/postgresql/9.6/main/pg_hba.conf
After everything is configured I'm running odoo server from /opt/odoo/odoo10.0/odoo-bin
I've encountered this error! The detailed error says:
Odoo ver : 10 & postgresql ver : 9.6
Database User :postgres
password for postgres: passwd
Help needed! Thanks in Advance