Skip to main content
The database used by Live Agent is PostgreSQL. It can either run inside the Kubernetes cluster as an additional workload, or outside the cluster. You can also use a fully managed solution for PostgreSQL. Compatible and tested PostgreSQL versions are later than 10 and earlier than 15.

​
Postgres Variables

KeyTypeDefaultDescription
postgresql.enabledbooltrueSet to false if using an external postgres, and modify the below variables.
postgresql.nameOverridestring"postgresql"Pod Name Override
postgresql.auth.databasestring"live_agent_production"
postgresql.auth.usernamestring"postgres"Database User
postgresql.hoststring"postgres"Commented, unless using an external database.
postgresql.portstring"postgres"Commented, unless using an external database.
postgresql.SSLModestring"prefer"Database SSL Mode (prefer, require, disable)

​
Internal Setup

It is good practice to change the postgres.auth.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. An existing secret can also be used, and it needs to contain the keys postgresql-password and 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.auth.secretKeys.adminPasswordKey.