Deployment Issue with Azure Postgres on Kubernetes

Summary

User encounters a deployment error when using Azure Postgres Server with Airbyte on Kubernetes via helm charts. The error indicates a failure in the schema version compatibility check due to a missing ‘schema_version’ relation in the database.


Question

Hi all,
I am trying to deploy Airbyte on Kubernetes (AKS) using helm charts. I was able to make it work with the internal database. However, if I try to use it with Azure Postgres Server, the temporal pod does not get started and fails with the following error:

Unable to create server. Error: could not build arguments for function "<http://go.uber.org/fx|go.uber.org/fx>".(*module).constructCustomLogger.func2 (/go/pkg/mod/go.uber.org/fx@v1.20.0/module.go:251): failed to build fxevent.Logger: could not build arguments for function "<http://go.temporal.io/server/temporal|go.temporal.io/server/temporal>".init.func8 (/home/builder/temporal/temporal/fx.go:1029): failed to build log.Logger: received non-nil error from function "<http://go.temporal.io/server/temporal|go.temporal.io/server/temporal>".ServerOptionsProvider (/home/builder/temporal/temporal/fx.go:180): sql schema version compatibility check failed: unable to read DB schema version keyspace/database: temporal error: pq: relation "schema_version" does not exist.```

<br>

---

This topic has been created from a Slack thread to give it more visibility.
It will be on Read-Only mode here. [Click here](https://airbytehq.slack.com/archives/C021JANJ6TY/p1719491250424319) if you want
to access the original thread.

[Join the conversation on Slack](https://slack.airbyte.com)

<sub>
['kubernetes', 'helm', 'azure-postgres', 'temporal-error', 'schema-version']
</sub>