[Qgis-user] Connect to PostGIS Without Superuser Privileges

[Brent Wood]

Check the Postgres server pg_hba.conf to make sure the specified user/IP address has access to the required db.


Also, how are you trying to connect? The normal QGIS connection dialogue does not use the GDAL/OGR string you are defining.


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.

Cheers,

  Brent Wood



________________________________
From: Elijah Meeks <emeeks at stanford.edu>
To: qgis-user at lists.osgeo.org
Sent: Sunday, August 7, 2011 2:48 PM
Subject: [Qgis-user] Connect to PostGIS Without Superuser Privileges

QGIS comes back with the following error if I try to connect to PostGIS:

PG:dbname='databasename' host='hostname' port='5432' user='username' password='password' is not a valid or recognized data source

(Databasename, hostname, username and password are all correct, I just changed them to generic values for this post)

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?

Thanks,
Elijah

************
Elijah Meeks
http://dhs.stanford.edu
Digital Humanities Specialist
Academic Computing Services
Stanford University
emeeks at stanford.edu
(650)387-6170
_______________________________________________
Qgis-user mailing list
Qgis-user at lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/qgis-user
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20110806/af6101db/attachment.html>