Hello, I've tried finding the solution on my own, but have been unable to understand (from PostGIS and PostgreSQL documentation, and from web searches). Basically, no problem installing or using PostGIS with a superuser account (not the "postgres" user however), but can't event run select postgis_full_version(); in some cases as a "normal" user.
In one case, the DBA ran the "create extension postgis" command as the "postgres" superuser, but although the "normal" user could create tables with default PostgreSQL types, impossible to create anything like a geometry or geography column (permissions error: type "geography" doesn't exist). Unless I've been looking in the wrong places (not impossible), the guides quickly run through the installation steps without going into detail. I'd like to understand how to do this without resorting to the superuser, and without blindy running random commands from different forums. I'm using PostgreSQL 9.6.1 with PostGIS 2.3.1 from ppa repositories on Ubuntu 14.04 LTS. Thanks in advance. -- Christopher _______________________________________________ postgis-users mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/postgis-users
