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.

  • Slashzero@hakbox.social
    link
    fedilink
    arrow-up
    2
    ·
    edit-2
    1 year 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.

      • Slashzero@hakbox.social
        link
        fedilink
        arrow-up
        1
        ·
        1 year ago

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

    • example@reddthat.com
      link
      fedilink
      arrow-up
      1
      ·
      1 year ago

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