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

[Sandro Santilli]

On Mon, May 07, 2012 at 09:14:32AM +0200, Sandro Santilli wrote:
> 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.

Oh, another thing: I installed postgis using the old school scripts,
not the EXTENSION model (which may do things differently).

--strk;

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