3
submitted 1 month ago by ch00f@lemmy.world to c/selfhost@lemmy.ml

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

you are viewing a single comment's thread
view the rest of the comments
[-] ch00f@lemmy.world 1 points 1 month ago

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.

this post was submitted on 29 Apr 2025
3 points (80.0% liked)

Self Hosted - Self-hosting your services.

12522 readers
2 users here now

A place to share alternatives to popular online services that can be self-hosted without giving up privacy or locking you into a service you don't control.

Rules

Important

Beginning of January 1st 2024 this rule WILL be enforced. Posts that are not tagged will be warned and if not fixed within 24h then removed!

Cross-posting

If you see a rule-breaker please DM the mods!

founded 4 years ago
MODERATORS