[Qgis-user] Connect to PostGIS Without Superuser Privileges

[Elijah Meeks]

I resolved this problem.  It seems I was trying to GRANT permissions with a superuser in phpPgAdmin.  Logging in with postgres at the terminal allowed me to GRANT access as I wanted to the tables.

-Elijah

************
Elijah Meeks
http://dhs.stanford.edu
Digital Humanities Specialist
Academic Computing Services
Stanford University
emeeks at stanford.edu
(650)387-6170

----- Original Message -----
From: "Elijah Meeks" <emeeks at stanford.edu>
To: "Brent Wood" <pcreso at pcreso.com>
Cc: qgis-user at lists.osgeo.org
Sent: Saturday, August 6, 2011 8:33:27 PM
Subject: Re: [Qgis-user] Connect to PostGIS Without Superuser Privileges

Hi Brent,

I'm connecting via the Add Vector Layers dialogue.  It works fine if the role is a superuser--and the hb_conf is set up correctly.

Thanks,
Elijah

************
Elijah Meeks
http://dhs.stanford.edu
Digital Humanities Specialist
Academic Computing Services
Stanford University
emeeks at stanford.edu
(650)387-6170

----- Original Message -----
From: "Brent Wood" <pcreso at pcreso.com>
To: "Elijah Meeks" <emeeks at stanford.edu>
Cc: qgis-user at lists.osgeo.org
Sent: Saturday, August 6, 2011 8:10:44 PM
Subject: Re: [Qgis-user] Connect to PostGIS Without Superuser Privileges



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