How to get a list of users on your instance (guide for administrators).
How to get a list of users on your instance (guide for administrators).
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.
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.
2 0 ReplyYeah, I do that on my home server but my VPS had passwordless sudo by default so I was too lazy to do this.
1 0 ReplyFair 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. 😃
1 0 Reply
thank you!
Would be nice to see some more UI built-in admins tools for user admin.
2 0 Reply