[postgis-users] Do I have to be a superuser to use postgis extensions?

Sandro Santilli strk at keybit.net
Sun May 6 01:31:16 PDT 2012


On Sat, May 05, 2012 at 10:58:24PM -0700, Donovan Cameron wrote:

> When I to check the postgis version with the user saultdon, it says
> postgis_topology not installed. I have to be superuser to use it.
...
> *NOTICE:  Function postgis_topology_scripts_installed() not found. Is
> topology support enabled and topology.sql installed?*

Try
GRANT usage on schema topology to public;

Or variations of the above. When satisfied consider doing it on the
template database.

--strk;

  ,------o-. 
  |   __/  |    Delivering high quality PostGIS 2.0 !
  |  / 2.0 |    http://strk.keybit.net - http://vizzuality.com
  `-o------'




More information about the postgis-users mailing list