Thank you for enlightening me on the -W
option in psql. I have successfully logged in using the expected password for lemmy. This points to something with the connection string. According to the error log, the connection string being used is:
postgres://lemmy:<my percent-encoded password>@postgres:5432/lemmy
As far as I can tell, the percent encoding is correct. Any ideas how to troubleshoot this further?
This makes sense, and I do have a dollar sign in my password…
However, I have confirmed that postgres does in fact parse the password correctly, as I can log in with the defined username/password combo directly using
psql
So I think that disproves this theory, doesn’t it?
edit: I tried getting rid of the dollar sign just in case… unfortunately I’m still getting the same error