PostgreSQL Setup

DATABASE_URL=postgres://<user>:<password>@<host>:5432/dashboard_auth?schema=public
CORE_DATABASE_URL=postgres://<user>:<password>@<host>:5432/cobi_core?schema=public

postgresql:
  enabled: true
  image:
    tag: "16"
  auth:
    username: postgres
    password: "<strong-password>"
    database: dashboard_auth
  primary:
    initdb:
      scripts:
        create-core-db.sql: |
          CREATE DATABASE cobi_core;
    resources:
      requests:
        cpu: 250m
        memory: 512Mi
      limits:
        cpu: "1"
        memory: 2Gi
    persistence:
      enabled: true
      storageClass: ""    # use cluster default; set to "local-path" for on-prem
      size: 10Gi

<release-name>-postgresql:5432

--from-literal=DATABASE_URL="postgres://postgres:<password>@cobi-dashboard-postgresql:5432/dashboard_auth?schema=public" \
--from-literal=CORE_DATABASE_URL="postgres://postgres:<password>@cobi-dashboard-postgresql:5432/cobi_core?schema=public"

postgresql:
  primary:
    persistence:
      storageClass: "local-path"
      size: 20Gi

postgresql:
  enabled: false

CREATE DATABASE dashboard_auth;
CREATE DATABASE cobi_core;
GRANT ALL PRIVILEGES ON DATABASE dashboard_auth TO <username>;
GRANT ALL PRIVILEGES ON DATABASE cobi_core TO <username>;

kubectl create secret generic cobi-backend-secrets \
  --namespace cobi \
  --from-literal=DATABASE_URL="postgres://<user>:<password>@<pg-host>:<port>/dashboard_auth?schema=public" \
  --from-literal=CORE_DATABASE_URL="postgres://<user>:<password>@<pg-host>:<port>/cobi_core?schema=public" \
  # ... other variables

apiVersion: v1
kind: Service
metadata:
  name: postgres-external
  namespace: cobi
spec:
  type: ExternalName
  externalName: db.internal.example.com

apiVersion: v1
kind: Service
metadata:
  name: postgres-external
  namespace: cobi
spec:
  ports:
    - port: 5432
---
apiVersion: v1
kind: Endpoints
metadata:
  name: postgres-external
  namespace: cobi
subsets:
  - addresses:
      - ip: 192.168.1.50
    ports:
      - port: 5432

kubectl logs -n cobi deploy/cobi-dashboard-backend | grep -i "database\|migration\|postgres"