Lemmy Support

157 readers

1 users here now

Support / questions about Lemmy.

founded 5 years ago

MODERATORS

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

8 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 1 year ago* (last edited 1 year ago) (2 children)

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.

[–] example@reddthat.com 1 points 1 year ago

keep in mind that this effectively grants your user passwordless sudo permissions, which may not be what you want.

[–] bdonvr@lemmy.rogers-net.com 1 points 1 year 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 1 year 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 1 year ago

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