[Answered ]-Django Postgres docker-compose connection error mainly failed: FATAL: password authentication failed for user foobar ERROR: 2

thanks to @hedayat I realized that the spaces after = for environment variables in docker-compose are not the cause and the main cause was the in between step of creating django folders(project and the apps) the data\db gets created and it doesn’t let the authentication happen. so by deleting data\db I was able to do migrate the database.