I have created a username,password & ssh key with root privileges on a remote server (Vagrant) and I am attempting to connect via the usual methods but my password authentication fails. I can successfully ssh into the server using the same credentials.
How can I configure QGIS to connect to PostgreSQL/PostGIS using an ssh key?