documentation about postgres mode

[v0lkan]

// For postgres backing store, VSecM Safe should keep its initial config
// in memory until the database is there; and then it should save it to
// the database, too. -> Document this too!

^ plus other things. -- a mini recording would be useful too; especially showcasing recent changes

0. create postgres-enabled manifests
1. deploy everyting
2. configure postgres
3. run tests
4. show db records.

more

helm install my-postgres bitnami/postgresql

CREATE TABLE "vsecm-secrets" (name TEXT PRIMARY KEY, data TEXT);

kubectl run my-postgres-postgresql-client --rm --tty -i --restart='Never' --namespace default --image docker.io/bitnami/postgresql:17.0.0-debian-12-r1 --env="PGPASSWORD=$POSTGRES_PASSWORD" \
  --command -- psql --host my-postgres-postgresql -U postgres -d postgres -p 5432

k exec $S -n vsecm-system -- safe
-w vsecm-safe
-s '{"config":{"backingStore":"postgres","dataSourceName":"postgresql://postgres:[email protected]:5432/postgres?sslmode=disable"}}'

2024/10/12 17:31:01 [WARN] iBCfGnni TODO: fetch from postgres store