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.
Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
- CRM
- e-Commerce
- Accounting
- Inventory
- PoS
- Project
- MRP
This question has been flagged
2
Replies
51139
Views
Hi,
Please read this blog, where the same criteria is explained in detail:- Professional Odoo 11 Deployment Guid
In the postgres:
Then update the odoo conf file with this db host and port.
Thanks
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)
Enjoying the discussion? Don't just read, join in!
Create an account today to enjoy exclusive features and engage with our awesome community!
Sign up| Related Posts | Replies | Views | Activity | |
|---|---|---|---|---|
|
2
Jul 20
|
7085 | ||
|
|
0
Mar 19
|
4 | ||
|
1
Nov 24
|
5796 | ||
|
4
Nov 19
|
2631 | ||
|
Postgresql not connecting.
Solved
|
|
1
Feb 19
|
8226 |
