I have a fresh Azure Linux VM based on Opengeo suite. The dashboard and geoserver are working. But I can't connect or configure postgis. I follow this guide.
Via putty, logged in with the only user azure gives you (wgadmin in my case), I enter: sudo -u postgres psql postgres
could not change directory to "/home/wgadmin": Permission denied psql: could not connect to server: No such file or directory Is the server running locally and accepting connections on Unix domain socket "/tmp/.s.PGSQL.5432"?
PSQL - V returns 9.3.5.
I have changed the postgres users password another way. I then go on to try and modify: /etc/postgresql/9.3/main/pg_hba.conf but it doesn't seem to be present.
Am I doing something wrong?
A fresh install should be easy to configure.