pgadmin in Kubernetes – mount Permission denied

If you are using Docker, or for this matter Kubernetes, you would need to mount a host folder into your container to store your data persistently. For pgadmin, you would like to persistently save the database, which holds all metadata and is per default located in pgadmin under /var/lib/pgadmin.

Given a PVC called pgadmin-data, you are most likely to deploy pgadmin in Kubernetes with the following yaml configuration.

apiVersion: apps/v1 # for versions before 1.9.0 use apps/v1beta2
kind: Deployment
  name: pgadmin-deploy
  replicas: 1
        app: pgadmin
        - image: dpage/pgadmin4:5.3
          name: pgadmin
          - containerPort: 80
            name: http
            protocol: TCP
            - name: pgadmin-data
              mountPath: /var/lib/pgadmin
        - name: pgadmin-data
            claimName: pgadmin-data

However you will likely encount the following error: Permission denied: ‘/var/lib/pgadmin/sessions’

This happens because, when you mount a PVC, it is per default mounted under root. However the pgadmin/dpage image runs as pgadmin user with the UID:GID of 5050:5050, which is why you will get an error message, trying to acces that folder.

A workaround could be, by initializing an initContainer first, to change the permission of the specific folder to an appropriate one .

- name: pgadmin-init
image: alpine
args: [ "sh", "-c", "chown 5050:5050 /var/lib/pgadmin " ]
- name: pgadmin-data
mountPath: /var/lib/pgadmin

In this this github issue it is suggested, that you could create a custom storageclass, which has specific mountoptions. However the oracle cloud, with which i had to work with, did not support mountoptions.

There also appears to be a solution setting fsgroup in the SecurityContext, but at this point i can not say for sure, whether this is helpful for the problem at hand (see stackoverflow)

Leave a Comment

Your email address will not be published. Required fields are marked *

hungsblog | Nguyen Hung Manh | Dresden
Scroll to Top