Skip to Content
This question has been flagged
postgresqlodoosh
1 Reply
4731 Views
Avatar
SOLUCIONES EN INGENIERIA TEKNIU


I have a server with odoo sh and an external one, I need to connect to the external db, I tried it with the postgresql dblink package, psql but it doesn't allow me to create the extension. ERROR: permission denied to create extension "dblink" How could I connect to the other db?

Avatar
Discard
Avatar
Niyas Raphy (Walnut IT)
Best Answer

Hi,

You can connect two odoo database using the xmlrpc ,

import xmlrpclib
url = 'http://0.0.0.0:8012'
db = 'db_name'
username = 'admin'
password = 'admin'

common = xmlrpclib.ServerProxy('{}/xmlrpc/2/common'.format(url))
uid = common.authenticate(db, username, password, {})
models = xmlrpclib.ServerProxy('{}/xmlrpc/2/object'.format(url))

Also see this video, showing how the data is transferred between two database using xmlrpc :-  Transfer Data Between Databases Using XMLRPC In Odoo : Database Migration


Odoo Doc : https://www.odoo.com/documentation/13.0/webservices/odoo.html

Thanks

Avatar
Discard
Related Posts Replies Views Activity
Workflow for Pushing Changes from Odoo.sh to GitHub Without Merging to the Main Branch
odoosh
Avatar
0
Dec 24
41
ODOO.sh Solved
odoosh
Avatar
Avatar
Avatar
2
Oct 24
2558
Changes Not Reflected in Jupyter Notebook on Odoo SH
odoosh
Avatar
Avatar
1
Sep 24
285
AttributeError: module 'lib' has no attribute 'X509_V_FLAG_CB_ISSUER_CHECK' when creating new staging branch Solved
odoosh
Avatar
Avatar
Avatar
Avatar
Avatar
8
Aug 24
46706
psycopg2.OperationalError: connection to server at "localhost" (::1), port 5432 failed: fe_sendauth: no password supplied
postgresql
Avatar
Avatar
1
Jul 24
3462