chore(helm): prepare chart defaults for PostgresAI 0.15

Maya Prequested to merge
neo/postgresai-helm-015-release-defaults into main

Summary

Release-readiness update for the PostgresAI 0.15 Helm chart and repo docs.

Changes

  • Set chart version and appVersion to 0.15.0.
  • Move pgwatch defaults from cybertecpostgresql/pgwatch:4.1.0 to postgresai/pgwatch:0.15.0.
  • Move Flask backend and reporter defaults to 0.15.0.
  • Document the instances.yml-preserving upgrade path with mon update + mon start, including the explicit PGAI_TAG=0.15.0 bump required for the new images to be pulled (mon update preserves PGAI_TAG, so without bumping it the stack would just re-pull the old version).
  • Pin README and cli/README.md install/upgrade examples to the final postgresai@0.15.0 release; no release-candidate install guidance remains in the committed docs.

Why

  • The helm-v0.15.0 release job rewrites only Chart.yaml version, so these defaults must be merged before tagging or the Helm package will ship stale images.
  • The release doc audit found repo docs still pointing at @beta / @rc / @latest and a local-install upgrade path that can rewrite instances.yml.

Validation

  • bash postgres_ai_helm/test-release-logic.sh passed: 40/40.
  • bash -n postgres_ai_helm/release.sh postgres_ai_helm/test-release.sh postgres_ai_helm/test-release-logic.sh passed.
  • CI validate-helm-chart runs helm lint + helm template + helm package on every MR that touches postgres_ai_helm/**; vm-auth:config:tests additionally runs helm lint + helm template.
  • Searched README.md, cli/README.md, and postgres_ai_helm/** for 0.15.0-rc, @rc, and release candidate; no matches remain.
  • Pipeline passed: https://gitlab.com/postgres-ai/postgresai/-/pipelines/2562303025

Review follow-ups (REV)

  • BLOCKING (PGAI_TAG contradiction): README Step 3 no longer claims mon update preserves PGAI_TAG and upgrades; it now instructs setting PGAI_TAG=0.15.0 before mon update/mon start.
  • BLOCKING (npm versions): release docs now target the final postgresai@0.15.0 release rather than rc/prerelease guidance.
  • BLOCKING (helm lint not run): clarified that CI runs helm lint/template/package; the "not installed" note referred only to the author's local runner.

Closes #215 (closed)

Edited by Maya P

Merge request reports