Minikube部署PostgreSQL无法持久化数据求助

我通过Minikube在Kubernetes中部署PostgreSQL数据库，执行以下命令将本地目录挂载到Minikube集群：

minikube start -p sandbox
minikube -p sandbox mount /home/mrrobot/Volumes:/mnt/data --port=39189

随后通过以下命令检查挂载目录权限：

minikube -p sandbox ssh
ls -al /mnt/data

确认目录权限正确：

drwxr-xr-x 1 docker docker 4096 Jan 16 11:07

我创建了PostgreSQL的Deployment部署清单及对应卷资源，所有组件运行正常，但重启Minikube后，之前创建的PostgreSQL用户消失，数据未持久化到指定卷中，每次重启都需要重新创建用户和数据库。Pod日志无报错，PostgreSQL运行正常。

我尝试改用StatefulSet部署，问题依旧。

部署清单 #

Deployment配置 #

apiVersion: apps/v1
kind: Deployment
metadata:
  name: postgres
  namespace: sandbox
  labels:
    environment: Development
    name: PostgresDeployment
spec:
  replicas: 1
  selector:
    matchLabels:
      name: PostgresPOD
  template:
    metadata:
      name: postgres-pod
      labels:
        name: PostgresPOD
        environment: Development
    spec:
      containers:
      - name: postgres-db
        image: postgres
        ports:
        - containerPort: 5432
        envFrom:
        - secretRef:
            name: postgres-db-secret
        resources:
          requests:
            cpu: "1"
            memory: "512Mi"
          limits:
            cpu: "2"
            memory: "1024Mi"
      volumes:
      - name: postgres-volume
        persistentVolumeClaim:
          claimName: postgres-pvc

PersistentVolume配置 #

apiVersion: v1
kind: PersistentVolume
metadata:
  name: postgres-pv
  namespace: sandbox
  labels:
    name:  postgres-pv
    environment: Development
spec:
  accessModes:
  - ReadWriteMany
  volumeMode: Filesystem
  storageClassName: standard
  capacity:
    storage: 10Gi
  hostPath:
    path:  /mnt/data

PersistentVolumeClaim配置 #

apiVersion: v1
kind: PersistentVolumeClaim
metadata:
  name: postgres-pvc
  namespace: sandbox
  labels:
    name: postgres-pvc
    environment: Development
spec:
  accessModes:
  - ReadWriteMany
  volumeMode: Filesystem
  resources:
    requests:
      storage: 8Gi

StatefulSet配置 #

apiVersion: apps/v1
kind: StatefulSet
metadata:
  name: postgres
  namespace: sandbox
spec:
  selector:
    matchLabels:
      app: postgres # has to match .spec.template.metadata.labels
  serviceName: postgres-service
  replicas: 1 # by default is 1
  minReadySeconds: 10 # by default is 0
  template:
    metadata:
      labels:
        app: postgres # has to match .spec.selector.matchLabels
    spec:
      containers:
      - name: postgres
        image: postgres
        ports:
        - containerPort: 5432
        envFrom:
        - secretRef:
            name: postgres-db-secret
        volumeMounts:
        - name: postgres-volume
          mountPath: /data
  volumeClaimTemplates:
  - metadata:
      name: postgres-volume
    spec:
      accessModes: [ "ReadWriteMany" ]
      storageClassName: standard
      volumeMode: Filesystem
      resources:
        requests:
          storage: 10Gi

核心原因 #

1. 卷挂载路径错误
   PostgreSQL官方镜像默认将数据存储在/var/lib/postgresql/data路径下，但你的配置：

   • Deployment未配置volumeMounts，卷根本没挂载到容器内的PostgreSQL数据目录
   • StatefulSet把卷挂载到了/data，而非PostgreSQL默认数据路径，导致数据实际未写入持久化卷，重启后自然丢失。

2. Minikube临时挂载失效
   使用minikube mount创建的挂载是临时挂载，Minikube重启后会自动失效，无法保留之前的挂载关系。

解决步骤 #

1. 修正PostgreSQL卷挂载路径 #

无论使用Deployment还是StatefulSet，都需要将持久化卷挂载到PostgreSQL默认数据路径/var/lib/postgresql/data，同时可通过subPath避免目录内其他文件干扰。

修正后的Deployment关键配置

spec:
  containers:
  - name: postgres-db
    image: postgres
    ports:
    - containerPort: 5432
    envFrom:
    - secretRef:
        name: postgres-db-secret
    # 新增卷挂载配置
    volumeMounts:
    - name: postgres-volume
      mountPath: /var/lib/postgresql/data
      subPath: postgres
    resources:
      requests:
        cpu: "1"
        memory: "512Mi"
      limits:
        cpu: "2"
        memory: "1024Mi"
  volumes:
  - name: postgres-volume
    persistentVolumeClaim:
      claimName: postgres-pvc

修正后的StatefulSet关键配置

spec:
  containers:
  - name: postgres
    image: postgres
    ports:
    - containerPort: 5432
    envFrom:
    - secretRef:
        name: postgres-db-secret
    # 修改挂载路径为PostgreSQL默认数据目录
    volumeMounts:
    - name: postgres-volume
      mountPath: /var/lib/postgresql/data
      subPath: postgres

2. 配置Minikube永久挂载本地目录 #

替换临时的minikube mount命令，在启动Minikube时直接指定挂载参数，确保重启后挂载依然有效：

minikube start -p sandbox --mount-string="/home/mrrobot/Volumes:/mnt/data" --mount

3. 验证权限与数据持久化 #

• 重新部署所有资源后，进入PostgreSQL容器创建测试用户和数据库
• 重启Minikube集群，再次进入容器检查数据是否存在
• 查看本地/home/mrrobot/Volumes/postgres目录下是否生成PostgreSQL数据文件

额外注意事项 #

• 若使用hostPath类型PV，需确保Minikube节点内/mnt/data/postgres目录权限匹配PostgreSQL用户（UID为999），可通过minikube ssh执行chown -R 999:999 /mnt/data/postgres修正权限
• 生产环境不建议使用hostPath，推荐使用Minikube自带的minikube-hostpath存储类

内容的提问来源于stack exchange，提问作者Amith Sai