[Django]-PyCharm: SSH Auth Fail when connecting to vagrant Postgres DB

You got almost everything right. The issue is that you are not able to login to the VM via ssh due to authentication failure as the error message states. I only managed to connect changing the auth method.

In order to do so, you must select Key pair authentication type and use vagrant’s private key, which is located in <vagrant root>/.vagrant/machines/default/virtualbox/private_key.

This is what my dialog looks like (I replaced my actual path with <my vagrant root>) :

The key at ~/.vagrant.d/insecure_private_key won’t work.

This answer helped me to connect with Pycharm, even though the author print screen displays a password based authentication.