@kapa.ai From which helm version of AI , SSL is compulsory in postgres

The information provided in the knowledge sources does not specify from which Helm version of Airbyte, SSL is compulsory in Postgres. However, it is mentioned that for Airbyte Cloud (and optionally for Airbyte Open Source), SSL should be enabled in your environment [source](https://docs.airbyte.com/integrations/sources/postgres/postgres-troubleshooting#version-requirements). For more specific information, you may want to refer to the official Airbyte documentation or their GitHub repository.

@kapa.ai How to enable SSL in postgres deployed on kubernetes

A message from kapa.ai

To enable SSL in a Postgres database deployed on Kubernetes with Airbyte, you can modify your Helm chart values. Here's an example of how to do it:

yaml temporal:   extraEnv:     - name: SQL_TLS       value: "true"     - name: SQL_TLS_ENABLED       value: "true"

If you're having trouble with the main Airbyte DB connection, you can use

jdbcUrl

to add `sslMode=require`:

yaml externalDatabase:   jdbcURL: jdbc:<postgresql://your-postgres-host/dbname?required_param=value&sslMode=require>

Temporal doesn't look at

jdbcURL

, it takes the other values from

externalDatabase

for

host

,

password

, and

database

and builds its own connection URL. Please note that these configurations are based on the information provided in the knowledge sources and may need to be adjusted based on your specific setup and requirements. For more detailed instructions, you may want to refer to the official Airbyte documentation or their GitHub repository. [Source](https://github.com/airbytehq/airbyte/issues/24201)

@kapa.ai can i make it value false as well

A message from kapa.ai

Yes, you can set the value to

false

if you want to disable SSL for your Postgres database in Airbyte. Here's how you can do it:

yaml temporal:   extraEnv:     - name: SQL_TLS       value: "false"     - name: SQL_TLS_ENABLED       value: "false"

And for the main Airbyte DB connection, you can modify the

sslMode

parameter in the `jdbcURL`:

yaml externalDatabase:   jdbcURL: jdbc:<postgresql://your-postgres-host/dbname?required_param=value&sslMode=disable>

Please note that these configurations are based on the information provided in the knowledge sources and may need to be adjusted based on your specific setup and requirements. For more detailed instructions, you may want to refer to the official Airbyte documentation or their GitHub repository. [Source](https://github.com/airbytehq/airbyte/issues/24201)

@kapa.ai after putting value as false , still getting this error

sql schema version compatibility check failed: pq: database "temporal" does not exist
Unable to create server. Error: could not build arguments for function "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 "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 "go.temporal.io/server/temporal".ServerOptionsProvider (/home/builder/temporal/temporal/fx.go:180): sql schema version compatibility check failed: pq: database "temporal" does not exist.

A message from kapa.ai

The error message you're seeing indicates that the "temporal" database does not exist. This could be due to a few reasons: 1. The database "temporal" has not been created yet. You need to create the "temporal" database in your PostgreSQL instance before Airbyte can connect to it. 2. The database name in your configuration might be incorrect. Ensure that the database name in your configuration matches the actual name of your database in PostgreSQL. 3. There might be a network issue preventing Airbyte from reaching your PostgreSQL instance. Ensure that your PostgreSQL instance is reachable from the Kubernetes cluster where Airbyte is running. Here's an example of how you can specify the database name in your configuration:

yaml temporal:   extraEnv:     - name: DBNAME       value: temporal

Please note that these configurations are based on the information provided in the knowledge sources and may need to be adjusted based on your specific setup and requirements. For more detailed instructions, you may want to refer to the official Airbyte documentation or their GitHub repository. [Source](https://github.com/airbytehq/airbyte/issues/26647)