Praveen
03/04/2026, 4:32 PMkapa.ai
03/04/2026, 4:33 PMairbyte-temporal pod is the key issue here:
unable to connect to DB, tried default DB names: postgres,defaultdb, errors: [pq: SSL is not enabled on the server pq: SSL is not enabled on the server]
This indicates that Temporal 1.27.2 is attempting to connect to your PostgreSQL database using SSL, but SSL is not enabled on your database server. This is a connectivity issue between Temporal and your external PostgreSQL instance, not necessarily a schema/namespace issue.
This is similar to a known pattern where Azure PostgreSQL (or other managed databases) require SSL certificates that aren't configured for the Temporal deployment. [Temporal Azure Postgres]
Here's what you should check and do:
1. Resolve the SSL Issue First
The airbyte-server error (UNAVAILABLE: io exception) is a downstream consequence of Temporal not starting properly. Fix the Temporal → PostgreSQL connection first.
• If your PostgreSQL instance does not support SSL, you may need to configure Temporal to connect without SSL (e.g., by setting POSTGRES_TLS_ENABLED=false or similar env vars via temporal.extraEnv in your values.yaml).
• If your PostgreSQL instance requires SSL, you need to provide the appropriate SSL certificates/configuration to the Temporal pod.
You can pass extra environment variables to the Temporal pod using the extraEnv field in your Helm values: [Values.yaml reference]
temporal:
extraEnv:
- name: SQL_TLS_ENABLED
value: "false"
# or configure SSL cert paths if SSL is required
2. Regarding Re-running Schema Setup
The knowledge sources do not explicitly confirm whether upgrading from Temporal 1.23.0 to 1.27.2 requires re-running the schema/namespace initialization. However, since Temporal cannot even connect to the database right now (due to the SSL error), the schema issue is secondary — you need to fix the SSL connectivity problem first.
Once Temporal can connect to PostgreSQL successfully, if you still see schema-related errors, you may need to re-run the schema setup steps you performed previously for 1.23.0.
Summary
1. Fix the SSL mismatch between Temporal 1.27.2 and your PostgreSQL instance (either disable SSL on the Temporal side or enable/configure it on the DB side).
2. Once Temporal starts successfully, check if the airbyte-server error resolves on its own.
3. If schema/namespace errors persist after connectivity is restored, you may need to re-initialize the schema and namespace.
I'd recommend checking your PostgreSQL server's SSL configuration and aligning it with what Temporal 1.27.2 expects. 👍 0 button 👎 0 button ℹ️ Tip: Mention @kapa.ai in the thread for follow-ups or DM the app for 1-to-1 help.