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 <eme...@stanford.edu>
To: qgis-user@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
eme...@stanford.edu
(650)387-6170
_______________________________________________
Qgis-user mailing list
Qgis-user@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/qgis-user
_______________________________________________
Qgis-user mailing list
Qgis-user@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/qgis-user