## 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:   
   - 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`.