can we get the postgres admin access for odoo.sh
Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
- 客户关系管理
- e-Commerce
- 会计
- 库存
- PoS
- 项目
- MRP
此问题已终结
3
回复
7831
查看
Hi,
This is not possible because the Odoo hosting platforms (Odoo Online and Odoo.sh) do not expose the postgresql clusters to the internet.
If you need to communicate with a third party system/application (E-commerce, BI reporting, ...), you will need to setup the integration at the http layer.
Keep in mind that in case you need to periodically import data into an Odoo.sh database, you should use the #load() method of the model you want to import into (instead of making one rpc request per row to create/update) otherwise the requests might be rate limited.
Link: https://www.odoo.sh/faq
odoo xml rpc: https://www.youtube.com/watch?v=isjhwKAL63M
Thanks
We do not provide direct access. It conflicts with our security, performance and uptime SLA's.
If your Use Case is "building reports" then you are better off automating a backup and restore to a data warehouse.
If your Use Case is "auditing" then you are better off enhancing track changes on fields you care about.
Or you can move on premise and be responsible for keeping Odoo running fast and reliably 99.99% of the time.
You cannot access the database from outside odoo.sh but you can from the terminal in odoo.sh. So if needed you can upload a python script that makes use of psycopg2 and easily connect to postgres using the credentials found in environment variables :
import os
import psycopg2
conn = psycopg2.connect('dbname=%s user=%s host=%s password=%s' % tuple(os.environ[v] for v in ('PGDATABASE', 'PGUSER', 'PGHOST', 'PGPASSWORD')))
which is eventually equivalent to:
import os
import psycopg2
conn=psycopg2.connect('')
"odoo.sh implementation" is not a question, I have updated your title to be a question, please consider using questions in the future so not everyone has to open your post to find out what you are asking.