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

Powiązane posty	Odpowiedzi	Widoki
Odoo closes connection to DB on GCP Cloud SQL for longpolling requests and Causing 404 Error Rozwiązane postgresql odoo12	2 lip 20	8142
How to connect Odoo with Postgresql postgresql odoo12	0 mar 19	5
PostgreSQL_for_Odoo can't run postgresql odoo12 windows10	1 lis 24	7296
ODOO12 not creating db column? postgresql odoo12 ORM	4 lis 19	3574
Postgresql not connecting. Rozwiązane postgresql beginner odoo12	1 lut 19	9108

To pytanie dostało ostrzeżenie

Podoba Ci się ta dyskusja? Dołącz do niej!