PostgreSQL is running in Homestead by default, but you cannot access it from the host machine (though the docs do mention the 54320 forwarded port?)
Instead SSH into the Vagrant box and run migrations locally.
Putty on Windows. I had to convert the default private_key file to ppk. Use PuttyGen to generate a private key, use it as Auth option from putty and vagrant username.