<html><body><div style="color:#000; background-color:#fff; font-family:times new roman, new york, times, serif;font-size:12pt"><div><span>Check the Postgres server pg_hba.conf to make sure the specified user/IP address has access to the required db.<br></span></div><div><br></div><div>Also, how are you trying to connect? The normal QGIS connection dialogue does not use the GDAL/OGR string you are defining.<br></div><div><br></div><div>It prompts for an arbitrary name, a service I leave blank, the port (which defaults to 5432) the host & the database. Optional user & password. Quite a different syntaxt to yours.</div><div><br></div><div>Cheers,</div><div><br></div><div> Brent Wood<br></div><div><br></div><div style="font-family: times new roman,new york,times,serif; font-size: 12pt;"><div style="font-family: times new roman,new york,times,serif; font-size: 12pt;"><font face="Arial" size="2"><hr size="1"><b><span style="font-weight:
bold;">From:</span></b> Elijah Meeks <emeeks@stanford.edu><br><b><span style="font-weight: bold;">To:</span></b> qgis-user@lists.osgeo.org<br><b><span style="font-weight: bold;">Sent:</span></b> Sunday, August 7, 2011 2:48 PM<br><b><span style="font-weight: bold;">Subject:</span></b> [Qgis-user] Connect to PostGIS Without Superuser Privileges<br></font><br>QGIS comes back with the following error if I try to connect to PostGIS:<br><br>PG:dbname='databasename' host='hostname' port='5432' user='username' password='password' is not a valid or recognized data source<br><br>(Databasename, hostname, username and password are all correct, I just changed them to generic values for this post)<br><br>The connection works fine when the user/role I connect with is a superuser, but errors out above when I remove superuser status. I've GRANTed ALL access to the db and the tables for the role, but no change. I noticed a three year old bug
report/feature request similar to this, so I'm assuming I haven't got the right permissions set up. Any suggestions?<br><br>Thanks,<br>Elijah<br><br>************<br>Elijah Meeks<br><a href="http://dhs.stanford.edu" target="_blank">http://dhs.stanford.edu</a><br>Digital Humanities Specialist<br>Academic Computing Services<br>Stanford University<br><a ymailto="mailto:emeeks@stanford.edu" href="mailto:emeeks@stanford.edu">emeeks@stanford.edu</a><br>(650)387-6170<br>_______________________________________________<br>Qgis-user mailing list<br><a ymailto="mailto:Qgis-user@lists.osgeo.org" href="mailto:Qgis-user@lists.osgeo.org">Qgis-user@lists.osgeo.org</a><br><a href="http://lists.osgeo.org/mailman/listinfo/qgis-user" target="_blank">http://lists.osgeo.org/mailman/listinfo/qgis-user</a><br><br><br></div></div></div></body></html>