Have you checked out Aegis?
Edit: I missed the Linux requirement, not sure if Aegis works with that in mind
Have you checked out Aegis?
Edit: I missed the Linux requirement, not sure if Aegis works with that in mind
Glad you solved it! Definitely sounds like a better solution than playing around in the db
Oh 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) lemmy
being the username and the db name might also be lemmy
Edit: 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
You might be able to just run docker-compose exec postgres psql
to drop into a shell (you may still need to define the user with -U lemmy
)
If you’re trying to connect with ane external tool though, you’ll need to expose the ports temporarily, which I’m not sure if you can do without restarting the container (after adding the exposed ports to the docket compose file, like 127.0.0.1:5432:5432
)
Been a happy namecheap customer for probably around 10 years now, never had any issues!
Officially, no. I’m an avid caddy user for years and not looking to change, as I’m very comfortable with config files and cli, but I have to admit Zoraxy looks very slick!
I might give it a try soon, I’m starting to embrace more nice UI to work with although I’ll always feel most at home in the terminal
I looked into this last week for recurring tasks in an actix-web project and ended up picking fang, but haven’t really battle tested it… But seems to do what I need. I’m using cron tasks with Postgres as the backend to run a recurring task every minute.