Summary
Unable to connect to Odoo.sh Postgres server due to permission denied for table pg_database. Seeking manual configuration workaround.
Question
Hi all!
We are doing a test in which we want to extract data from an Odoo environment which is hosted in the cloud (Odoo.sh). We have been able to make a connection to the cloud environment and to access the Postgres server. We have limited access to this server and we see that we don’t have access to the tabel pg_database, but we do have access to the individual tables and are able to select records. When we try to set-up Airbyte from the cloud and use the Postgres server as a source, we get the error:
Could not connect with provided configuration. Error: ERROR: permission denied for table pg_database
Is there a way around this and configure this source manually / by a config file?
This topic has been created from a Slack thread to give it more visibility.
It will be on Read-Only mode here. Click here if you want
to access the original thread.