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 [email protected] (650)387-6170 ----- Original Message ----- From: "Elijah Meeks" <[email protected]> To: "Brent Wood" <[email protected]> Cc: [email protected] 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 [email protected] (650)387-6170 ----- Original Message ----- From: "Brent Wood" <[email protected]> To: "Elijah Meeks" <[email protected]> Cc: [email protected] 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 <[email protected]> To: [email protected] 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 [email protected] (650)387-6170 _______________________________________________ Qgis-user mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/qgis-user _______________________________________________ Qgis-user mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/qgis-user
