For the complete documentation index, see llms.txt.
Skip to main content
Version: 8.9

Use external PostgreSQL

The Helm chart deployment can optionally install an internal PostgreSQL using Bitnami subcharts. For production environments, we advise deploying PostgreSQL separately from the Camunda Helm charts. This guide steps through using an external PostgreSQL instance.

This page applies to Management Identity and Web Modeler. It does not apply to the Orchestration Cluster or Optimize.

In the Camunda Helm chart, Keycloak (identityKeycloak) is deprecated and disabled by default. If you use the bundled Keycloak, its database is provisioned by an internal PostgreSQL sub-chart. The chart only lets you supply a password secret for that internal database; it does not support connecting Keycloak to a separately hosted external PostgreSQL instance. See internal Keycloak for the supported credential options, or connect to an external identity provider such as Microsoft Entra ID or a generic OIDC provider to avoid deploying Keycloak's database entirely.

Prerequisites​

  • Running external PostgreSQL service
  • Connection details: following sample values are used in this guide (replace them with your own):
host: `db.example.com`
port: `5432`
username: `postgres`
password: `examplePassword`
  • Supported versions:: Check the supported environments and RDBMS support policy pages to confirm which PostgreSQL versions are supported.
  • Database setup: Ensure the required databases exist in your PostgreSQL instance. For this guide, create the following databases:
CREATE DATABASE "web-modeler";
CREATE DATABASE "management-identity";
  • Kubernetes secrests: Store the database password in a Kubernetes secret so it is not referenced in plain text within your values.yaml (This secret exists outside the Helm chart and will not be overwritten by subsequent helm upgrade commands). For example:
kubectl create secret generic camunda-psql-db --from-literal=password=examplePassword -n camunda

Configuration​

Two Camunda 8 Self-Managed components can connect to an external PostgreSQL instance through this guide: Management Identity and Web Modeler. Configure each component to connect to the external PostgreSQL instance.

Parameters​

values.yaml optiontypedefaultdescription
webModeler.restapi.externalDatabase.urlstring""JDBC url of the database
webModeler.restapi.externalDatabase.userstring""Username of the database
webModeler.restapi.externalDatabase.secret.existingSecretstring""Kubernetes Secret name containing a database password
webModeler.restapi.externalDatabase.secret.existingSecretKeystring""Key within the Kubernetes Secret that has the database password
webModeler.restapi.externalDatabase.secret.inlineSecretstring""string literal of the database password if not using a Kubernetes Secret
identity.externalDatabase.enabledbooleanfalseEnable the externalDatabase options
identity.externalDatabase.hoststring""Hostname of the database
identity.externalDatabase.portinteger5432Port of the database
identity.externalDatabase.usernamestring""Username of the database
identity.externalDatabase.secret.existingSecretstring""Kubernetes Secret name containing database password
identity.externalDatabase.secret.existingSecretKeystring""Key within the Kubernetes Secret that contains the database password
identity.externalDatabase.databasestring""Database name
note

Earlier versions of this page also listed identityKeycloak.externalDatabase.* parameters. As of chart version camunda-platform-8.9-14.0.0, those parameters don't exist. The bundled Keycloak sub-chart only supports identityKeycloak.postgresql.auth.existingSecret and identityKeycloak.postgresql.auth.secretKeys.adminPasswordKey / userPasswordKey to override the password of its own internal PostgreSQL database, described in internal Keycloak. It doesn't support connecting to a separately hosted external PostgreSQL instance.

Example usage​

webModeler:
enabled: true
restapi:
mail:
fromAddress: noreply@camunda.mycompany.com
fromName: Camunda 8 WebModeler
externalDatabase:
url: "jdbc:postgresql://db.example.com:5432/web-modeler"
user: "postgres"
secret:
existingSecret: "camunda-psql-db"
existingSecretKey: "password"

identity:
externalDatabase:
enabled: true
host: "db.example.com"
port: 5432
username: "postgres"
secret:
existingSecret: "camunda-psql-db"
existingSecretKey: "password"
database: "management-identity"

Troubleshooting​

  • If Management Identity's database is misconfigured, other applications will output a 401 error code in the logs as they are not able to correctly authenticate.
  • If you have not created the databases in your external PostgreSQL instance, a database missing error will output in the logs of the respective component.

References​