19
you are viewing a single comment's thread
view the rest of the comments
view the rest of the comments
this post was submitted on 20 Aug 2023
19 points (95.2% liked)
Lemmy Support
4652 readers
1 users here now
Support / questions about Lemmy.
founded 5 years ago
MODERATORS
After executing
docker exec -it lemmymydomain_postgres_1 psqlI've got the error:
psql: error: connection to server on socket "/var/run/postgresql/.s.PGSQL.5432" failed: FATAL: role "root" does not existOh yeah, try specifying the hostname as localhost (I think it's -h, but --help will confirm it). Psql tries by default to connect to that socket, but in docker it does use it.
Basically, you'll need to specify the hostname and user (and if port, which should just be default, then -p 5432)
It should be
docker exec -it lemmymydomain_postgres_1 psql -h localhost -U lemmy (dbname)Keeping in mind that you'll need to have the right user and database name, assuming (based on your original comment)
lemmybeing the username and the db name might also be lemmyEdit: this should btw just get you into the db, I have no idea of its a good idea or not to delete a user directly from the db, it might cause issues, but I don't have experience with it, but just generally use postgres in docker with other projects
I found a solution here
A warning to people who have the same problem:
On the website there is a command, which will purge all unverified account. If your admin account wasn't verified, it will be purged, too.
Thanks a lot for your help :)
Glad you solved it! Definitely sounds like a better solution than playing around in the db
Well, it is playing around with the db ๐ ... and it could even destroy the whole instance if people don't see the warning I've posted there.