Issue deploying Airbyte on Kubernetes cluster with Temporal pod unable to connect to external Postgres database

Summary

Temporal pod in Airbyte on Kubernetes cluster is unable to connect to external Postgres database


Question

Hey there ! I have issue deploying airbyte on Kubernetes cluster especially with temporal pod that is not able to connect to external postgres database.



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

["airbyte", "kubernetes-cluster", "temporal-pod", "external-postgres-database"]

I’m getting the following issue
ERROR Unable to create SQL database. {"error": "unable to connect to DB, tried default DB names: postgres,defaultdb, errors: [pq: no pg_hba.conf entry for host \"10.2.1.93\", user \"postgres\", database \"postgres\", SSL off pq: no pg_hba.conf entry for host \"10.2.1.93\", user \"postgres\", database \"defaultdb\", SSL off]", "logging-call-at": "handler.go:94"}

However airbyte pods can correctly connect to external postgres database after creating airbyte db on postgresql server.

It seems that temporal deployment does not pick up all values given from the chart.

does anybody has encountered such issue ?

Found answers on this thread https://github.com/airbytehq/airbyte/issues/11157#issuecomment-1716659762