Database configuration

Configure the SQL Stream Builder's database.

By default, the Helm chart automatically creates a PostgreSQL Deployment and Service using a public image. The Helm chart also creates a PersistentVolumeClaim, which will persist throughout Helm uninstalls and installs using the "helm.sh/resource-policy": "keep" annotation.

If you remove this PersistentVolumeClaim, on the next SSB restart all the data saved by SSB will be lost, and the database will be re-created.

It is recommended that you use an already existing external database, and configure SSB to connect to it, instead of using the default created database. You can use MySQL/MariaDB, Oracle or PostgreSQL as a database.

You can use the following example configuration to override the default database configuration:

database:
  create: false
  auth:
	type: postgresql
	jdbcUrl: "jdbc:postgresql://postgres-host:5432/ssb_admin"
	username: test_user
	password: test_password

The data provided here is kept secure as a Kubernetes secret.