Skip to content

Database

The database used by Live Agent is PostgreSQL. It can either run inside of the Kubernetes cluster as an additional workload, or outside of the cluster. You can also use a fully managed solution for PostgreSQL.

Compatible and tested PostgreSQL versions >= 10 and <= 14

Postgres Variables

Key Type Default Description
postgresql.enabled bool true Set to false if using an external postgres, and modify the below variables.
postgresql.nameOverride string "postgresql" Pod Name Override
postgresql.postgresqlDatabase string "live_agent_production"
postgresql.postgresqlUsername string "postgres" Database User
postgresql.postgresqlHost string "postgres" Commented, unless using an external database.
postgresql.postgresqlPort string "postgres" Commented, unless using an external database.
postgresql.postgresSSLMode string "prefer" Database SSL Mode (prefer, require, disable)

Internal Setup

It is good practice to change the postgres.postgresqlPassword in the values.yaml file. To do this, you can change the value, or comment on the line postgresqlPassword: postgres before installing the Helm chart, which will autogenerate a password.

External Setup

  1. Go to the values.yaml file and scroll down to postgresql field. Change the enabled value to false.

  2. Type the user credentials and uncomment the properties postgresqlHost, postgresqlPort, giving them the correct values.

  3. Define a password to access the external Postgres instance:

    • A. A secret is created by default. Edit the password inside the Postgres secret. The secret name is composed of the release name + postgres.
    • B. (Recommended) Define an existing secret. Create the secret and set the values inside the values.yaml file. The keys are postgresql.existingSecret and postgresql.existingSecretPasswordKey.
Back to top