Is it possible to specify SSL communication in the...
# replication-ask-ai
s
Is it possible to specify SSL communication in the DB required by Airbyte? If so, is it necessary to prepare server-side certificates?
k
A message from kapa.ai
New message text here
s
@kapa.ai Sorry for the misunderstanding. I am not asking about SSL for the connector, but whether SSL connection is possible in the connection between airbyte-db and airbyte-server.
👍 1
k
A message from kapa.ai
Yes, SSL connection is possible between the Airbyte database and the Airbyte server. You can configure the connection to an external Postgres database with SSL by setting the
DATABASE_URL
and
CONFIG_DATABASE_URL
environment variables with the appropriate JDBC connection string, including the SSL parameters. For example, you can set the
DATABASE_URL
like this:
Copy code
DATABASE_URL=jdbc:<postgresql://host.docker.internal:3000/postgres?ssl=true&sslmode=require>
And for the config database, if it is separate from the job database:
Copy code
CONFIG_DATABASE_URL=jdbc:postgresql://<host>:<port>/<database>?<extra-parameters>
Replace
<host>
,
<port>
,
<database>
, and
<extra-parameters>
with the appropriate values for your setup. Source: [Configuring the Airbyte Database](https://docs.airbyte.com/operator-guides/configuring-airbyte-db)
s
@kapa.ai Thank you. Do I need a Server side certificate in this case?
k
A message from kapa.ai
Yes, you will need a server-side certificate when using SSL for the connection between the Airbyte database and the Airbyte server. The certificate should be installed and configured on your Postgres server to enable SSL encryption. For more information on configuring SSL for Postgres, you can refer to the [official PostgreSQL documentation](https://www.postgresql.org/docs/current/ssl-tcp.html). Please note that the provided information extracts do not specifically cover the process of setting up a server-side certificate for the Airbyte database. However, the general process of setting up SSL for a Postgres server should be applicable.