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

Login to your server, execute the following commands:

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

Very excited to build a Texans community on the Fediverse! Suggestions? Let me know!

New communities don't show up on other servers until at least one user goes looking for it! I don't have an account on any other instances so I'd appreciate if you could help, especially if you're on a large instance and nobody else has done it yet.

Just search "![email protected]" (without the qoutes) or copy and paste the full URL in your instance's search bar while you're signed in. It might say "not found" but it should now appear in the communities tab. Oh and subscribe, if you're interested.

Thanks! Welcome to lemmy and the fediverse! See you all gameday

Discuss the event live here!

Livestream: https://www.youtube.com/watch?v=GYkq9Rgoj8E