Error connecting to Odoo.sh Postgres server in Airbyte

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.

Join the conversation on Slack

["odoo.sh", "postgres-server", "airbyte", "permission-denied", "manual-configuration"]

We were able to create the source by using the Airbyte API and it looked liked it worked (instead of it creating it by the gui). When we configure the connection we are also able to see the tables of the schema we want to extract from. We do get an error when we run the sync (in our case to S3), but there is no error message. Does anyone have ideas / thoughts?

I have the same error pg_database when going from a postgreSQL connection. How did you create yours ? Maybe i can figure it out

MADE IT. Downgrade de Postgres connector version to http://localhost:8000/workspaces/a34f7d0d-fb8a-4214-b115-3aa64d2f5a36/source/80fb9620-1bc1-4109-926e-7e958eb898b9#changelog|3.6.18 and it will work just fine