Lemmy Support

4651 readers

1 users here now

Support / questions about Lemmy.

founded 6 years ago

MODERATORS

submitted 2 years ago by bdonvr@lemmy.rogers-net.com to c/lemmy_support@lemmy.ml

6 comments fedilink hide all child comments

I was trying to figure out how to do this, there's no easy way but there is at least a way.

(Use sudo for docker if it gives a permission error. If you manually installed, well I'm sure you can figure it out then lmao)

docker ps

From the output of that find the name of the docker container running Postgres.

docker exec -it DOCKER_NAME_HERE bash

psql -U lemmy -h 127.0.0.1 -p 5432 -d lemmy

\c lemmy

SELECT name from person WHERE local='t';

You can also do name,display_name instead of just "name" in the comment above to see their custom display name.

Hope this helps someone.

you are viewing a single comment's thread
view the rest of the comments

[–] slashzero@hakbox.social 2 points 2 years ago (1 children)

You can add the ‘docker’ group to your user, then log out an in again, and you erring need studio anymore for docker commands.

Thanks for this tip, by the way.

[–] bdonvr@lemmy.rogers-net.com 1 points 2 years ago (1 children)

Yeah, I do that on my home server but my VPS had passwordless sudo by default so I was too lazy to do this.

[–] slashzero@hakbox.social 1 points 2 years ago (1 children)

Fair enough. New “sysadmins” might not know that though, so I thought I’d share that tip.

Not a criticism in any way, but I would also recommend not using the default user name and password for the Postgres DB. 😃

[–] bdonvr@lemmy.rogers-net.com 1 points 2 years ago

Heh. Username is default but isn't the password defined in the docker file? That's not default.