[postgis-devel] Lower Priv Users and PostGIS

Paul Ramsey pramsey at opengeo.org
Wed Nov 28 09:17:43 PST 2012

# createdb -O weak weak
# psql -U weak weak

weak=> \d
No relations found.
weak=> create extension postgis;
ERROR:  permission denied to create extension "postgis"
HINT:  Must be superuser to create this extension.
weak=> \q

# psql -U postgres weak

weak=# create extension postgis;
weak=# \q

# psql -U weak weak
weak=> \d
              List of relations
 Schema |       Name        | Type  |  Owner
 public | geography_columns | view  | pramsey
 public | geometry_columns  | view  | pramsey
 public | raster_columns    | view  | pramsey
 public | raster_overviews  | view  | pramsey
 public | spatial_ref_sys   | table | pramsey
(5 rows)

weak=> select * from geometry_columns ;
ERROR:  permission denied for relation geometry_columns
weak=> \q

Do we want this to be the default, or do we want low-priv users to be
able to use PostGIS after install?

More information about the postgis-devel mailing list