this post was submitted on 23 May 2022
2 points (100.0% liked)
Lemmy Support
4652 readers
1 users here now
Support / questions about Lemmy.
founded 5 years ago
MODERATORS
you are viewing a single comment's thread
view the rest of the comments
view the rest of the comments
docker-compose exec postgres psql -U lemmy
I change the database name to lemmyok in docker-compose.yml and lemmy.hjson, and use the command "docker-compose exec postgres psql -U lemmyok" and get " psql: error: FATAL: role "lemmyok" does not exist ",can't enter PG.
If I use the command docker-compose exec postgres psql -U lemmy without changing the database name, I can enter PG normally.
Am I doing something wrong?
What should be the correct solution?
-U is for the postgres user, not the database. you can pass that with -d