[postgis-users] postgis for non-superuser user

[alex bodnaru]

hi,

i wrote it.

please use it.

alex

Shoaib Burq wrote:
> Thanks Markus,
> 
> 
>>If you can call "create database", then you actually _are_ superuser, right?
> 
> 
> Hummm... not as I understand it. a non-superuser can create db's but
> may not be able to create a procedural language or define the C
> functions.
> 
> 
>>And for installing PostGIS into a database, you need to define some 'C'
>>functions. As 'C' is considered an "unsafe" language by PostgreSQL (you
>>can bypass the whole security system), you need superuser rights for this.
> 
> 
> So the upshot: no-superuser no postgis db? :(
> 
> 
>>The debian installation has a template_postgis database, AFAIR.
> 
> 
> I wonder if there's anything stopping me from using that on Gentoo?
> 
> cheers
> shoaib
> --
> http://geospatial.nomad-labs.com
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>