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.