[Qgis-developer] login to postgres/postgis from QGIS

[Olivier Dalang]

Is your database spatially enabled ? Try to run 'create extension postgis;"
in pgadmin.

Bests,

Olivier
On Feb 27, 2015 8:08 AM, "Otto Dassau" <dassau at gbd-consult.de> wrote:

> Hi,
>
> I cannot login to a postgis database with QGIS as a normal user 'testuser'.
> But I can login with psql and using pgadmin3.
>
> CREATE ROLE testuser LOGIN
>   NOSUPERUSER INHERIT NOCREATEDB NOCREATEROLE NOREPLICATION;
>
> I get following error in QGIS:
>
> CET ERROR:  function postgis_version() does not exist at character 8
> CET HINT:  No function matches the given name and argument types. You might
> need to add explicit type casts.
> CET STATEMENT:  SELECT postgis_version()
>
> If I create another user as SUPERUSER I can login without problems. What
> could be the reason for this?
>
> Thanks a lot
> Otto
> _______________________________________________
> Qgis-developer mailing list
> Qgis-developer at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/qgis-developer
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-developer/attachments/20150303/b8121c12/attachment.html>