Error connecting to DB and schema version compatibility check failed

Slack Knowledge Base Q&A Connector Questions
, , , ,
1

Summary

The user is facing errors while trying to connect to the database. The errors include ‘no pg_hba.conf entry for host’ and ‘schema version compatibility check failed’. Connection settings and firewall are confirmed to be correct.


Question

Can anybody help this this error:
{"error": "unable to connect to DB, tried default DB names: postgres,defaultdb, errors: [pq: no pg_hba.conf entry for host \"20.26.1.43\", user \"xx\", database \"postgres\", no encryption pq: no pg_hba.conf entry for host \"20.26.1.43\", user \"x\", database \"defaultdb\", no encryption]", "logging-call-at": "handler.go:94"}
The connection settings / firewall are all configured correctly. It creates the airbyte schema objects. I even created the temporal database manually, and in addition to the above, it also gives the following error:
sql schema version compatibility check failed: unable to read DB schema version keyspace/database: temporal error: pq: relation "schema_version" does not exist


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

["error", "connecting-to-db", "schema-version", "pg-hba.conf", "firewall"]
2

are the database variables correctly set up in your deployment? every time I faced these errors it was because of a problem with my connection variables.