Skip to Content
This question has been flagged
3 Replies
5731 Views
Avatar
manoj@ial.com

    can we get the postgres admin access for odoo.sh

Avatar
Discard
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.

Avatar
Niyas Raphy (Walnut IT)
Best Answer

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
Avatar
Discard
Avatar
Ray Carnes (ray)
Best Answer

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.

Avatar
Discard
Avatar
Christophe Combelles
Best Answer

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('')
Avatar
Discard