[postgis-devel] Re: PostGIS datastore creation

Markus Schaber schabi at logix-tt.com
Wed Sep 27 07:24:50 PDT 2006


Hi, all,

alex bodnaru wrote:
> 
> i would also favourably comment, that using a template database might
> *allow a non dba user to create databases*, provided this user has
> createdb privileges, and access to the tables in the template database.

The most important part is that pg_database.datistemplate is set to
true, and it might may sense to set datallowconn to false.

HTH,
Markus

-- 
Markus Schaber | Logical Tracking&Tracing International AG
Dipl. Inf.     | Software Development GIS

Fight against software patents in Europe! www.ffii.org
www.nosoftwarepatents.org



More information about the postgis-devel mailing list