apiVersion: apps/v1 kind: StatefulSet metadata: name: postgresql spec: serviceName: "postgresql" replicas: 1 selector: matchLabels: app: postgresql template: metadata: labels: app: postgresql spec: containers: - name: postgresql image: postgres:latest resources: limits: cpu: "2" memory: "4Gi" requests: cpu: "1" memory: "2Gi" env: - name: POSTGRES_PASSWORD valueFrom: secretKeyRef: name: postgres-secret key: password volumeMounts: - mountPath: "/var/lib/postgresql/data" name: data-volume volumeClaimTemplates: - metadata: name: data-volume spec: accessModes: ["ReadWriteOnce"] resources: requests: storage: 1Gi --- apiVersion: autoscaling/v2beta2 kind: HorizontalPodAutoscaler metadata: name: postgresql-hpa spec: scaleTargetRef: apiVersion: apps/v1 kind: StatefulSet name: postgresql minReplicas: 1 maxReplicas: 3 metrics: - type: Resource resource: name: cpu target: type: Utilization averageUtilization: 70 - type: Resource resource: name: memory target: type: AverageValue averageValue: 3Gi --- apiVersion: v1 kind: Service metadata: name: postgresql-svc spec: type: ClusterIP selector: app: postgresql ports: - port: 5432 targetPort: 5432