[postgis-users] How to use PostGIS without being a superuser

[Christopher BROWN]

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