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


Ignore:
Timestamp:
06/13/16 14:35:05 (5 years ago)
Author:
Fran Boon
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • UserGuidelines/GIS/Data

    v239 v240  
    161161
    162162[wiki:InstallationGuidelinesGISDataLinux#PostGIS PostGIS] is recommended as the main data store.
    163 * Allow Read access to !GeoServer:
     163* Create a dedicated DB for GIS data:
     164{{{
     165su postgres
     166psql
     167CREATE USER gis WITH PASSWORD 'GIS';
     168\q
     169createdb -O gis gis
     170psql
     171\c gis
     172CREATE EXTENSION postgis;
     173GRANT CONNECT ON DATABASE gis to geoserver;
     174GRANT SELECT ON gis_location to geoserver;
     175GRANT SELECT ON geometry_columns to geoserver;
     176GRANT SELECT ON spatial_ref_sys to geoserver;
     177}}}
     178
     179* Allow Read access to !GeoServer to the Sahana DB:
    164180{{{
    165181su postgres