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

[Sandro Santilli]

On Sun, May 06, 2012 at 12:36:35PM -0700, Donovan Cameron wrote:

> Even though the GRANT USAGE has been used on template_postgis and my user
> saultdon can access the template_postgis and use 'SELECT
> postgis_full_version();' on it successfully, the user saultdon can create a
> new database from template_postgis but will lose access to the topology
> schema within the new db...

I can't confirm, after trying with PostgreSQL 8.4.10.
Can you report the error message you get when trying to use topology within
the new db ? The only problem I see is with search_path not retaining the
value of the template.

--strk; 

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