Based on the information provided, it seems like you’re trying to connect Airbyte to an external PostgreSQL database. Here are some steps you can follow: 1. Disable the default Postgres database (airbyte/db
) in the charts/airbyte/values.yaml
file: yaml postgresql: enabled: false
2. Enable and configure the external Postgres database in the charts/airbyte/values.yaml
file: yaml externalDatabase: host: ## Database host user: ## Non-root username for the Airbyte database database: db-airbyte ## Database name port: 5432 ## Database port number
3. For the non-root user’s password which has database access, you may use password
, existingSecret
or jdbcUrl
. We recommend using existingSecret
, or injecting sensitive fields from your own external secret store. Each of these parameters is mutually exclusive: yaml externalDatabase: ... password: ## Password for non-root database user existingSecret: ## The name of an existing Kubernetes secret containing the password. existingSecretPasswordKey: ## The Kubernetes secret key containing the password. jdbcUrl: "jdbc:postgresql://<user>:<password>@localhost:5432/db-airbyte" ## Full database JDBC URL. You can also add additional arguments.
4. The optional jdbcUrl
field should be entered in the following format: jdbc:<postgresql://localhost:5432/db-airbyte>
. We recommend against using this unless you need to add additional extra arguments can be passed to the JDBC driver at this time (e.g. to handle SSL). Please note that currently, Airbyte only supports external PostgreSQL databases. Also, ensure that your external PostgreSQL instance is version 13 as that’s the version Airbyte requires for connection. If you’re still facing issues, it might be helpful to check if both the database and Airbyte are on the same VPC. You could also try installing psql in one of the containers and try to connect to the database. If you’re able to connect with psql but still facing issues with Airbyte, it might be an issue with the configuration of Airbyte for external psql connectivity. Sources: - Configuring the Airbyte Database - Forum Post: Failed to connect to external postgres DB > Answers Part 6 - Forum Post: Connect Airbyte to External MS SQL database > Answers