Reputation: 1
I want to deploy my postgreSQL database with kubernetes but the database is not created...I put POSTGRES_DB in env of the deployment.
the kubernetes deployment of postgres work very well but no "qr_auth" database created.
deployment:
apiVersion: apps/v1
kind: StatefulSet
metadata:
name: postgres-deployment
labels:
app: postgres
spec:
serviceName: "postgres-service"
replicas: 1
selector:
matchLabels:
app: postgres
template:
metadata:
labels:
app: postgres
spec:
containers:
- name: postgres
image: postgres:17.4
env:
- name: POSTGRES_PASSWORD
valueFrom:
secretKeyRef:
name: qr-auth-secret
key: DB_PASSWORD
- name: POSTGRES_USER
valueFrom:
secretKeyRef:
name: qr-auth-secret
key: DB_USER
- name: POSTGRES_DB
value: qr_auth
resources:
requests:
memory: "256Mi"
cpu: "250m"
limits:
memory: "512Mi"
cpu: "1000m"
ports:
- containerPort: 5432
volumeMounts:
- name: postgres-storage
mountPath: /var/lib/postgresql/data
volumeClaimTemplates:
- metadata:
name: postgres-storage
spec:
accessModes: [ "ReadWriteOnce" ]
resources:
requests:
storage: 5Gi
---
apiVersion: v1
kind: Service
metadata:
name: postgres-service
spec:
selector:
app: postgres
ports:
- port: 5432
targetPort: 5432
configmap:
apiVersion: v1
kind: ConfigMap
metadata:
name: qr-auth-config
data:
DB_HOST: "postgres-service"
DB_PORT: "5432"
DB_NAME: "qr_auth"
secret:
apiVersion: v1
kind: Secret
metadata:
name: qr-auth-secret
type: Opaque
data:
DB_USER: cG9zdGdyZXM= # postgres en base64
DB_PASSWORD: cm9vdA== # root en base64
Upvotes: 0
Views: 31