4

I'm trying to setup PostgreSQL on Minikube with data path being my host folder mounted on Minikube (I'd like to keep my data on host).

With the kubernetes object created (below) I get permission error, the same one as here How to solve permission trouble when running Postgresql from minikube? although the question mentioned doesn't answer the issue. It advises to mount minikube's VM dir instead.

---
apiVersion: apps/v1
kind: Deployment
metadata:
  name: postgres
  labels:
    app: postgres
spec:
  replicas: 1
  selector:
    matchLabels:
      app: postgres
  template:
    metadata:
      labels:
        app: postgres
    spec:
      containers:
      - name: postgres
        image: postgres          
        volumeMounts:
          - mountPath: /var/lib/postgresql/data
            name: storage
        env:
        - name: POSTGRES_PASSWORD
          value: user
        - name: POSTGRES_USER
          value: pass
        - name: POSTGRES_DB
          value: k8s
      volumes:
        - name: storage
          hostPath:
            path: /data/postgres

Is there any other way to do that other than building own image on top of Postgres and playing with the permissions somehow? I'm on macOS with Minikube 0.30.0 and I'm experiencing that with both Virtualbox and hyperkit drivers for Minikube.

Michal Ostruszka
  • 2,089
  • 2
  • 20
  • 23
  • Have you tried to change the owner of `/var/lib/postgresql/data` via `initContainer` in the same way as described [here](https://stackoverflow.com/questions/51801220/postgres-on-kubernetes-volume-permission-error)? – Nick_Kh Nov 20 '18 at 13:12

1 Answers1

1

Look at these lines from here : hostPath

the files or directories created on the underlying hosts are only writable by root. You either need to run your process as root in a privileged Container or modify the file permissions on the host to be able to write to a hostPath volume

So, either you have to run as root or you have to change the file permission of /data/postgres directory.

However, you can run your Postgres container as root without rebuilding docker image.

You have to add following to your container:

securityContext:
  runAsUser: 0

Your yaml should look like this:

apiVersion: apps/v1
kind: Deployment
metadata:
  name: postgres
  labels:
    app: postgres
spec:
  replicas: 1
  selector:
    matchLabels:
      app: postgres
  template:
    metadata:
      labels:
        app: postgres
    spec:
      containers:
      - name: postgres
        image: postgres          
        volumeMounts:
        - mountPath: /var/lib/postgresql/data
          name: storage
        env:
        - name: POSTGRES_PASSWORD
          value: user
        - name: POSTGRES_USER
          value: pass
        - name: POSTGRES_DB
          value: k8s
        securityContext:
          runAsUser: 0
      volumes:
      - name: storage
        hostPath:
          path: /data/postgres
Emruz Hossain
  • 4,764
  • 18
  • 26
  • 1
    Using `securityContext` doesn't help. Getting `chown: changing ownership of '/var/lib/postgresql/data': Input/output error`. In minikube I see host dir being mounted with uid=501 and gid=20 which is totally crazy (taken from host) and moreover it cannot be changed even as root (getting permission denied) – Michal Ostruszka Nov 19 '18 at 20:36
  • https://stackoverflow.com/users/7695859/emruz-hossain please tell me you solved this somehow? I've also tried working with this: https://stackoverflow.com/questions/57947463/kubedb-on-minikube-mount-local-directory – Naim Salameh Oct 03 '19 at 22:51