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:
Find the location of the directory inside the container information:
docker inspect xivocc_pgxivocc_1 | grep volumes
Command output should give something like this:
"Source": "/var/lib/docker/volumes/82898d65ae41174865211ff709c12b1f5e7b3c1b7d26e73500b6e6c7cffb3f10/_data",
Use the result above to change the permissions:
chmod -R 700 /var/lib/docker/volumes/82898d65ae41174865211ff709c12b1f5e7b3c1b7d26e73500b6e6c7cffb3f10/_data
Restart the container:
xivocc-dcomp restart pgxivocc