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

[Donovan Cameron]

Using the GRANT sql worked. I read more about it in the postgresql manual.
Thanks.

GRANT USAGE ON SCHEMA topology TO PUBLIC;

Then It never fully took effect till I restarted the server,
*su -*
*rcpostgresql restart*
*exit*

Done.

Now, that part about giving access to PUBLIC on the template_postgis
database.
This is because without it, a non-superuser cannot create a database of
their own when using:
*createdb -T template_postgis newdb*
*createdb: database creation failed: ERROR:  permission denied to copy
database "template_postgis"*

I tried using the similar GRANT for databases but it doesn't mention
anything about allowing users to copy. Only connect, so I tried that:
*GRANT CONNECT ON DATABASE template_postgis TO PUBLIC;*

But still, cannot create a database without being postgres user.
Not sure if I need to maybe make user of ALTER like so:
*ALTER DATABASE template_postgis OWNER TO PUBLIC;*
Or try,
*ALTER ROLE saultdon CREATEDB IN DATABASE template_postgis;*

Does one of those give me copy permissions because CONNECT hasn't.

Thanks for the help so far with changing schema privileges.




Donovan

On Sun, May 6, 2012 at 1:31 AM, Sandro Santilli <strk at keybit.net> wrote:

> 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------'
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20120506/35984b7c/attachment.html>