Self hosting: invalid command to manually verify all users

[kyrofa]

First of all, your self-hosting docs are excellent. That said, there's a small bug in the command provided to verify accounts:

$ docker exec hosting_plausible_db_1 psql -U postgres -d plausible_db -c "UPDATE users SET email_verified = true;"
Error: No such container: hosting_plausible_db_1

Now, I'm using docker-compose v2.5.0. Here, the container names look like this:

$ docker-compose ps
NAME                            COMMAND                  SERVICE               STATUS              PORTS
hosting-mail-1                  "docker-entrypoint.s…"   mail                  running             25/tcp
hosting-plausible-1             "/entrypoint.sh sh -…"   plausible             running             0.0.0.0:8000->8000/tcp, :::8000->8000/tcp
hosting-plausible_db-1          "docker-entrypoint.s…"   plausible_db          running             5432/tcp
hosting-plausible_events_db-1   "/entrypoint.sh"         plausible_events_db   running             9009/tcp

Notice the hyphens versus underscores, there. A simple fix would be to simply change the docker command to use the proper container name:

$ docker exec hosting-plausible_db-1 psql -U postgres -d plausible_db -c "UPDATE users SET email_verified = true;"

That feels fragile, though. Are container name formats stable in docker-compose? I don't know, but it feels a little internal-API-ish. It seems like it would be better to use docker-compose itself for this:

$ docker-compose exec plausible_db psql -U postgres -d plausible_db -c "UPDATE users SET email_verified = true;"