title: Heroku pg:push psql: FATAL: password authentication failed for user
body: <p>I know similar questions have been asked but none of the solutions have worked. I am trying to push my local db to my Heroku db, and I keep getting psql: FATAL:  password authentication failed for user "windows username".</p>
  
  <p>I am on windows, so I tried SET PGUSER=postgres SET PGPASSWORD=password</p>
  
  <p>Then ran  heroku pg:push localdb DATABASE_URL --app herokuapp</p>
  
  <p>But am still getting this stupid password error. The thing is it still looks like it is using my windows user name and not postgres username.... how do I resolve this? </p>