[postgis-users] postgis for non-superuser user
schabi at logix-tt.com
Wed Apr 19 07:57:35 PDT 2006
Shoaib Burq wrote:
> is there an easy way to allow non-postgresql-superuser users to create
> postgis enabled databases. I am running the most recent postgis gentoo
If you can call "create database", then you actually _are_ superuser, right?
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.
> I haven't noticed any postgis templates.
The debian installation has a template_postgis database, AFAIR.
Markus Schaber | Logical Tracking&Tracing International AG
Dipl. Inf. | Software Development GIS
Fight against software patents in EU! www.ffii.org www.nosoftwarepatents.org
More information about the postgis-users