113 reputation
4
bio website gisjay.wordpress.com
location Arkansas
age 30
visits member for 1 year, 6 months
seen Mar 28 '13 at 17:08

I am a Master's Student in the School of Forest Resources at the University of Arkansas at Monticello. My work focuses on applying GIS to ecology and natural resources management.


Mar
16
comment QGIS PostGIS Authentication Failure with “trust” option
Thanks, that was the bit of understanding I was missing!
Mar
16
awarded  Scholar
Mar
16
accepted QGIS PostGIS Authentication Failure with “trust” option
Mar
15
comment QGIS PostGIS Authentication Failure with “trust” option
This sounds like it might be the problem. I was able to get a working connection this morning, but I changed a number of things at once (see my most recent comment on my question) and I haven't had time yet to isolate which change fixed the problem. I will try this out on a fresh user/db later.
Mar
15
comment QGIS PostGIS Authentication Failure with “trust” option
I tried this again, and your are right about entering "gis" in the database field. I had that mixed up, I suppose. I was still having trouble with my connections, though. I re-created the user and db from scratch, paying careful attention to creation options, and added an additional line to pg_hba.conf: local gis jay trust to explicitly give me access to that specific database. I was then able to connect, when filling in the fields in the way you suggested. However, I changed too many things at once, so I can't yet isolate what fixed it. Will report back later.
Mar
15
awarded  Supporter
Mar
15
awarded  Autobiographer
Mar
15
awarded  Student
Mar
13
asked QGIS PostGIS Authentication Failure with “trust” option