Trying to purge them and set up with Lemmy Ansible, I’ve disabled signups without admin approval for now.

I see a postgres container and a password but I’m not very familiar with postgres, I tried psql but can’t get access

Edit: Also anyone who’s de-federated with us, please reconsider. We’re a small server and will get a handle on this, I promise!

  • coffeeisnotlatte@latte.isnot.coffeeOP
    link
    fedilink
    English
    arrow-up
    3
    ·
    1 year ago

    Yeah that’s the issue I’m having, someone sent me a postgres command in DM earlier but it does seem to be a bit of a nuke/picking up ordinary users…

    • Bilb!@lem.monster
      link
      fedilink
      English
      arrow-up
      2
      ·
      1 year ago

      I wound up adding adminer to the docker-compose file temporarily to help me look through the data. In my case, there were no legitimate users who hadn’t verified their email, so I deleted all from local_users where the email verified column was false.

        • Bilb!@lem.monster
          link
          fedilink
          English
          arrow-up
          2
          ·
          edit-2
          1 year ago

          Yeah, I really just did a very basic setup:

          adminer: image: adminer restart: always ports: - 8080:8080

          When entering the database host, just enter “postgres” since that’s the host name it will have in the virtual network.

            • Bilb!@lem.monster
              link
              fedilink
              English
              arrow-up
              1
              ·
              1 year ago

              Great!

              For me, psql at the command line is great in a pinch but not great for any kind of complex task. I’ll probably add adminer as a permanent option, but only served locally + add a VPN to the server, or figure out how to get my preferred DB tool (DataGrip) to connect via SSH.

              There should be some management tools available via the GUI to lemmy admins, though. I’m so tempted to try to add it but I’m (generously) a rust novice.