تخطي للذهاب إلى المحتوى
لقد تم الإبلاغ عن هذا السؤال
3 الردود
7809 أدوات العرض
الصورة الرمزية
manoj@ial.com

    can we get the postgres admin access for odoo.sh

الصورة الرمزية
إهمال
Ray Carnes (ray)

"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.

الصورة الرمزية
Niyas Raphy (Walnut Software Solutions)
أفضل إجابة

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
الصورة الرمزية
إهمال
الصورة الرمزية
Ray Carnes (ray)
أفضل إجابة

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.

الصورة الرمزية
إهمال
الصورة الرمزية
Christophe Combelles
أفضل إجابة

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('')
الصورة الرمزية
إهمال