chart-postgresql

This chart is intended for adding the postgres sql databases.

Prerequisites

• To use this chart, you need a postgres Flexible server created beforehand.
• See cnp-flux-config PR link where the Flexible server is deployed using ASO.
• Follow this documentation for generating the PosgreSQL secret and see below for an example:

brew install sops

NAMESPACE=probate # adjust this for your Kubernetes namespace
PASSWORD=$(LC_ALL=C tr -dc 'A-Za-z0-9' </dev/urandom | head -c 16 ; echo)
kubectl create secret generic postgres \
  -n $NAMESPACE --from-literal=PASSWORD=${PASSWORD} --type=Opaque -o yaml \
  --dry-run=client > postgres.enc.yaml


KEY=https://dcdcftappsdemokv.vault.azure.net/keys/sops-key/7a5cc0c79b02466c86bc594c431e00f7
sops --encrypt --azure-kv ${KEY}  --encrypted-regex "^(data|stringData)$" --in-place postgres.enc.yaml

Example configuration

flexibleserver: "<flexible server name>"
location: uksouth
setup:
  databases:
   - name: "<name of the database>"

Please see example PR chart-ccd

Pull Request Validation

A build is triggered when pull requests are created. This build will run helm lint, deploy the chart using ci-values.yaml and run helm test.

Release Build

Triggered when the repository is tagged (e.g. when a release is created). Also performs linting and testing, and will publish the chart to ACR on success.

Releases

We use semantic versioning via GitHub releases to handle new releases of this application chart, this is done via automation called Release Drafter. When you merge a PR to master, a new draft release will be created. More information is available about the release process and how to create draft releases for testing purposes in more depth