Implement PostGres on Remote Server

Question

Hi Guys
Has anyone implemented postgres as a remote database server?
We are trying to put application on one server and postgres on another which means we need to change odoo.conf file to point to the other server and we have tried that with no success.
Any help or pointers appreciated. :)
Thanks
Rohit

Axel Mendoza · Accepted Answer

Hi Rohit
You just need to set the database connection parameters in the Odoo config like:
db_host = 127.0.0.1
db_port = 5432
db_user = odoo
db_password = odoo See more about it here:
https://www.odoo.com/documentation/9.0/reference/cmdline.html#database
Those command line arguments have their correspondent config option as explained here:
https://www.odoo.com/documentation/9.0/reference/cmdline.html#configuration-file

Rohit Thakral · Answer

Thanks Axel and Fasluca
Regards
Rohit

相關帖文	回覆	瀏覽次數
How to automatically logout upon closing of the browser window postgresql odoo9	1 7月 16	6208
Get all data from a model 已解決 database postgresql odoo9	1 12月 19	10907
how to run my odoo module on internet? postgresql localhost odoo9	1 9月 19	4022
When Odoo 14 connects to PostgreSQL 15.7, the connection is idle but cannot be released postgresql	0 2月 25	1028
psycopg2.OperationalError: connection to server at "localhost" (::1), port 5432 failed: fe_sendauth: no password supplied postgresql	2 1月 25	7286

此問題已被標幟

喜歡這則討論？不要只閱讀，加入發表意見吧！