FATAL: password authentication failed for user “postgres”

I did find any solution to this stupid ambiguous error message online, not even chat-gpt knows about it 😡

This error message could be a result of many issues. on my end, I found that another process was listing to the same port (5432) as the Postgres container so I just terminated it then it worked like a charm.
on windows:
- get the processes listening to port 5432 (or whatever port you configured)

netstat -ano | findstr "5432"

if you find more than one process, terminate your Postgres container

docker stop <container name or id>

Get the remaining process id and terminate it

taskkill /PID <PID> /F

Restart your Postgres container and connect to it.