Can we get access to PostgreSQL when using Odoo.sh?

Question

can we get the postgres admin access for odoo.sh

Niyas Raphy (Walnut Software Solutions) · Accepted 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 ro

Ray Carnes (ray) · 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.

Christophe Combelles · 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.co

Se marcó esta pregunta

¿Le interesa esta conversación? ¡Participe en ella!