apiVersion: apps/v1
kind: StatefulSet
metadata: { name: postgres, namespace: uqo-chat }
spec:
  serviceName: postgres
  replicas: 1
  selector: { matchLabels: { app: postgres } }
  template:
    metadata: { labels: { app: postgres } }
    spec:
      containers:
        - name: postgres
          image: pgvector/pgvector:pg16
          ports: [{ containerPort: 5432 }]
          env:
            - { name: POSTGRES_DB, value: uqochat }
            - { name: POSTGRES_USER, value: uqo }
            - { name: POSTGRES_PASSWORD, valueFrom: { secretKeyRef: { name: uqo-chat-secrets, key: POSTGRES_PASSWORD } } }
          volumeMounts: [{ name: pgdata, mountPath: /var/lib/postgresql/data }]
  volumeClaimTemplates:
    - metadata: { name: pgdata }
      spec: { accessModes: [ReadWriteOnce], resources: { requests: { storage: 20Gi } } }