How to connect Odoo with Postgresql?

Question

How to connect Odoo with Postgresql.
Odoo running in one machine, Postgresql running in another machine.
My requirement is i have to run odoo and postgresql in two different machines.

Cybrosys Techno Solutions Pvt.Ltd · Accepted Answer

Hi,
Please read this blog, where the same criteria is explained in detail:- Professional Odoo 11 Deployment Guid [1]

In the postgres:

Then update the odoo conf file with this db host and port.
Thanks

[1] https://mohamedhammad.info/blog/odoo-blog-1/post/professional-odoo-11-deployment-guide-2

Sudhir Arya (ERP Harbor Consulting Services) · Answer

You just need to pass "*db_host=IP_of_DB_INSTANCE"* & "*db_port=DATABASE_PORT (by default it is 5432)*"
Now, you need to change the postgres config file which will allow the IP of Odoo Instance to connect postgres.
Open: */etc/postgresql/9.5/main/pg_hba.conf *and make changes in following section:
# IPv4 local connections:
host all all 127.0.0.1/32  trust
host all all IP_of_Odoo_INSTANCE/24 trust
Save the file and restart the postgres server (*sudo service postgres  restart*)

İlgili Gönderiler	Cevaplar	Görünümler
Odoo closes connection to DB on GCP Cloud SQL for longpolling requests and Causing 404 Error Çözüldü postgresql odoo12	2 Tem 20	7179
How to connect Odoo with Postgresql postgresql odoo12	0 Mar 19	4
PostgreSQL_for_Odoo can't run postgresql odoo12 windows10	1 Kas 24	5897
ODOO12 not creating db column? postgresql odoo12 ORM	4 Kas 19	2714
Postgresql not connecting. Çözüldü postgresql beginner odoo12	1 Şub 19	8303

Bu soru işaretlendi

Enjoying the discussion? Don't just read, join in!