I've been trying to access my database on the LSA VM and haven't had much luck, these are the steps I have taken so far
1. edited postgresql.conf to listen to my host ip address
2. edited postgresql client authetication config file to have a trust for my host ip
3. downloaded pgadmin and given the server details and port number for a new connection, im using the port specifcied for the app server, that doesn't work. I noticed there is a different port in the postgresql.conf file, i tried using this with the same ip and this didn;t work either.