Datenbank

Die von Live Agent verwendete Datenbank ist PostgreSQL. Sie kann entweder innerhalb des Kubernetes-Clusters als zusätzliche Workload oder außerhalb des Clusters ausgeführt werden. Sie können auch eine vollständig verwaltete Lösung für PostgreSQL verwenden.

Kompatible und getestete PostgreSQL-Versionen >= 10 und <= 15

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.auth.database	string	"live_agent_production"
postgresql.auth.username	string	"postgres"	Database User
postgresql.host	string	"postgres"	Commented, unless using an external database.
postgresql.port	string	"postgres"	Commented, unless using an external database.
postgresql.SSLMode	string	"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:

4. A. A secret is created by default. Edit the password inside the Postgres secret. The secret name is composed of the release name + postgres.
5. 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.