Lemmy Support

4921 readers

2 users here now

Support / questions about Lemmy.

founded 6 years ago

MODERATORS

submitted 2 years ago by [email protected] to c/[email protected]

3 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.

top 2 comments

sorted by: hot top controversial new old

[–] [email protected] 2 points 2 years ago* (last edited 2 years ago)

thank you!

Would be nice to see some more UI built-in admins tools for user admin.

[–] [email protected] 1 points 2 years ago* (last edited 2 years ago)

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

sudo usermod -aG docker your_user

Thanks for this tip, by the way.