apiVersion: argoproj.io/v1alpha1
kind: Application
metadata:
  name: postgres
  namespace: argocd
spec:
  project: default
  sources:
    # Helm chart from Docker Hub OCI registry
    - repoURL: registry-1.docker.io/bitnamicharts
      chart: postgresql
      targetRevision: ">=18.0.0, <19.0.0"
      helm:
        values: |
          auth:
            existingSecret: postgres-passwords
            secretKeys:
              adminPasswordKey: postgres-password
          primary:
            persistence:
              size: 20Gi
            resources:
              requests:
                memory: 256Mi
                cpu: 100m
            initdb:
              scripts:
                create-kong-db.sql: |
                  CREATE DATABASE kong;
                  CREATE USER kong WITH PASSWORD '$(KONG_DB_PASSWORD)';
                  GRANT ALL PRIVILEGES ON DATABASE kong TO kong;
                  ALTER DATABASE kong OWNER TO kong;
  destination:
    server: https://kubernetes.default.svc
    namespace: platform
  syncPolicy:
    automated:
      prune: true
      selfHeal: true
    syncOptions:
      - CreateNamespace=true