[source-postgres] Could not connect with provided configuration. Error: ERROR: permission denied for table pg_database

[nilsdebruin]

Connector Name

source-postgres

Connector Version

3.6.20

What step the error happened?

Configuring a new connector

Relevant information

While trying to connect to a Postgres instance, we found that it was not possible to make a connection. We get the following message:

Could not connect with provided configuration. Error: ERROR: permission denied for table pg_database

We tried creating the connection through the API and that worked, but the connection could not sync in the end. When downgrading the connector to version 3.6.19 we are able to set-up the connection and the sync works. We are able to upgrade the connection afterwards, so it looks like it has to do with the initial set-up code / script.

The error occurs for all connector versions 3.6.20 and onwards.

This is the link to the thread in Slack: https://airbytehq.slack.com/archives/C021JANJ6TY/p1731503242140599

Relevant log output

Contribute

• Yes, I want to contribute