PostgreSQL

Container keeps on restarting after upgrade

After upgrading Docker it can sometimes happen that the container xivocc_pgxivocc_1 gets stuck in restarting mode. Logs show the following error

FATAL:  data directory "/var/lib/postgresql/data" has group or world access
DETAIL:  Permissions should be u=rwx (0700).

Error is caused by wrong permissions on the PostgreSQL data directory. Follow the below steps in order to fix the issue:

  1. Find the location of the directory inside the container information:

    docker inspect xivocc_pgxivocc_1 | grep volumes
    
  2. Command output should give something like this:

    "Source": "/var/lib/docker/volumes/82898d65ae41174865211ff709c12b1f5e7b3c1b7d26e73500b6e6c7cffb3f10/_data",
    
  3. Use the result above to change the permissions:

    chmod -R 700 /var/lib/docker/volumes/82898d65ae41174865211ff709c12b1f5e7b3c1b7d26e73500b6e6c7cffb3f10/_data
    
  4. Restart the container:

    xivocc-dcomp restart pgxivocc