Hi Team, is it possible to use external PostgreSQL...
# replication-ask-ai
r
Hi Team, is it possible to use external PostgreSQL database for the K8s Helm airbyte deployment ? I try to use values.yaml file with the hostname and credentials but I have a filling that airbyte still use internal DB that it creates. Thanks
k
A message from kapa.ai
Yes, it is possible to use an external PostgreSQL database for the K8s Helm Airbyte deployment. To do this, you need to configure the
values.yaml
file with the appropriate settings. Here are the steps to follow: 1. Set
postgresql.enabled
to
false
to disable the internal PostgreSQL database. 2. Configure the
externalDatabase
section with your external PostgreSQL instance details, such as host, user, password, database, and port. Here's an example of how your
values.yaml
file should look like:
Copy code
yaml postgresql:   enabled: false externalDatabase:   host: ${db_host}   user: ${db_user}   password: ${db_password}   database: ${db_name}   port: ${db_port}
Additionally, if you're using external DB secrets, provide them in
values.yaml
under the
global.database
section in the following format:
Copy code
yaml database:     secretName: "myOctaviaSecret"     secretValue: "postgresql-password"     host: "<http://example.com|example.com>"     port: "5432"
And upgrade the chart by running:
Copy code
helm upgrade -f path/to/values.yaml %release_name% airbyte/airbyte
Please note that the Helm charts are still in alpha, and there might be some issues. Make sure to review the [documentation](https://docs.airbyte.com/deploying-airbyte/on-kubernetes-via-helm) and [forum discussions](https://discuss.airbyte.io/t/2914) for more information and troubleshooting tips.
r
thanks
Is it also possible to store the all logs for airbyte in external storage like S3 bucket for k8s airbyte deployment with Helm? What values I need to add to values.yaml ?