I’m running funkwhale in docker. This consists of a half dozen docker containers one of which is postgres.
To run a backup, funkwhale suggests shutting down all of the containers and then docker compose running pg_dump on the postgres container. Presumably this is to copy the database when nobody is accessing it.
For some reason when I do this, I get an error like:
pg_dump: error: connection to server on socket "/var/run/postgresql/.s.PGSQL.5432" failed: No such file or directory
Is the server running locally and accepting connections on that socket?
It would seem that postgres isn’t running. I see the same error with other commands such as psql.
If I fully boot the container and then try exec-ing the command, it works fine.
So it would seem that the run command isn’t fully booting the instance before running the command? What’s going on here?
The container is built from postgres:15-alpine
Here’s the funkwhale page: https://docs.funkwhale.audio/administrator/upgrade/backup.html
Looks light a oversight on their part. Thanks for the advice.
I remember reading that copying a database while it’s in use is risky. Good to know pg_dump handles this correctly.