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

المنشورات ذات الصلة	الردود	أدوات العرض
Odoo closes connection to DB on GCP Cloud SQL for longpolling requests and Causing 404 Error تم الحل postgresql odoo12	2 يوليو 20	7311
How to connect Odoo with Postgresql postgresql odoo12	0 مارس 19	4
PostgreSQL_for_Odoo can't run postgresql odoo12 windows10	1 نوفمبر 24	6057
ODOO12 not creating db column? postgresql odoo12 ORM	4 نوفمبر 19	2832
Postgresql not connecting. تم الحل postgresql beginner odoo12	1 فبراير 19	8392

لقد تم الإبلاغ عن هذا السؤال

هل أعجبك النقاش؟ لا تكن مستمعاً فقط. شاركنا!