this post was submitted on 22 Jun 2023
14 points (100.0% liked)

Lemmy

12535 readers
2 users here now

Everything about Lemmy; bugs, gripes, praises, and advocacy.

For discussion about the lemmy.ml instance, go to !meta@lemmy.ml.

founded 4 years ago
MODERATORS
nutomic@lemmy.ml
14
Can you help me deal with the bots? (latte.isnot.coffee)
submitted 1 year ago* (last edited 1 year ago) by coffeeisnotlatte@latte.isnot.coffee to c/lemmy@lemmy.ml
19 comments fedilink hide all child comments
 

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 with active admin and will get a handle on this, I promise! We had an easy process to sign up for a few days while I got my users over and forgot to turn it off

Edit2: Looking much more healthy now, I will put the commands I've used in a comment below

you are viewing a single comment's thread
view the rest of the comments
[–] preciouspupp@sopuli.xyz 3 points 1 year ago

docker exec -it postgres sh export PGPASSWORD=$POSTGRES_PASSWORD psql -u $POSTGRES_USER

Something like this by heart.

PM me tomorrow if you are stuck (I’m in Europe).