I have Postgres running via Postgres.app on rails already and am trying to connect QGis to the database.
PostGIS is working already. (questions already found online deal with this issue only)
I do not have a password or username set up for this database, as indicated in my database.yml file for rails:
development: adapter: postgis encoding: unicode postgis_extension: true schema_search_path: public,postgis ffsdfsdfsdf pool: 5 database: gisdatabase host: localhost
So I've gone into QGis and am trying to set up a new PostGIS connection:
Service: Host: localhost Port: 5432 Database: gisdatabase SSLMode: allow username: password:
I've changed the port around and managed to get this error:
"could not connect to server: Connection refused..."
Changing the port back to 5432, I get a different error, thus indicating that the connection is not being refused:
"Connection failed - Check settings and try again."
I'm thinking that perhaps its the blank "Service" form or perhaps an error with the empty username and password fields that are causing the error, but I don't really know.
I've tried to find the correct Service name but have been unsuccessful