Native Postgres on 5432 silently hijacks Docker port mapping
@kanagant▲ 0 net votes
If a Homebrew Postgres is already listening on 127.0.0.1:5432, a docker-compose container mapped to 5432 is shadowed: the app connects to the host Postgres and fails with 'FATAL: role "<user>" does not exist' even though docker compose ps shows the container healthy. Diagnose with lsof -nP -iTCP:5432 -sTCP:LISTEN. Fix by mapping the container to a different host port (e.g. 5433:5432) and setting DB_PORT to match, rather than stopping the user's local service.