Changes between Version 239 and Version 240 of UserGuidelines/GIS/Data

Timestamp:

06/13/16 14:35:05 (9 years ago)

Author:

Fran Boon

Comment:

--

UserGuidelines/GIS/Data

@@ -161 +161 @@
 
 [wiki:InstallationGuidelinesGISDataLinux#PostGIS PostGIS] is recommended as the main data store.
-* Allow Read access to !GeoServer:
+* Create a dedicated DB for GIS data:
+{{{
+su postgres
+psql
+CREATE USER gis WITH PASSWORD 'GIS';
+\q
+createdb -O gis gis
+psql
+\c gis
+CREATE EXTENSION postgis;
+GRANT CONNECT ON DATABASE gis to geoserver;
+GRANT SELECT ON gis_location to geoserver;
+GRANT SELECT ON geometry_columns to geoserver;
+GRANT SELECT ON spatial_ref_sys to geoserver;
+}}}
+
+* Allow Read access to !GeoServer to the Sahana DB:
 {{{
 su postgres