Page History

...

By enabling the Postgres plugin, you gain access to Clowder's Geostreams API. This module supports definition of Sensors, Streams and Datapoints in Clowder that allow for geospatial visualization and querying. 

Installation & Initialization

1. Install Postgres
   
   
2. Create necessary database & roles in Postgres command-line

   • psql

   • CREATE DATABASE geostream;

   • CREATE ROLE clowder;

   • \\c geostream;

   • CREATE EXTENSION Postgis;

     


3. To prepare database tables, execute geostreams.sql (available on GitHub)

4. Install Postgres 
   1. https://wiki.postgresql.org/wiki/Detailed_installation_guides
5. Initialize the PostGIS database using SQL script in Clowder repository

   • https://opensource.ncsa.illinois.edu/bitbucket/projects/CATS/repos/clowder/browse/geostream.sql 

   • psql -d

   clowder

   • geostream -f

   clowder

   • ~/geostream.sql;

     


6. By default, the SQL script will assign database/tables to owner 'clowder'. If you specify a different Postgres user in Clowder (see Customization below) you should make sure databases/tables are owned by that user. 
   
   
7. Enable Postgres plugin in Clowder In by adding the following to clowder/custom/play.plugins include the line:
   • 10502:services.PostgresPlugin



Once installed you should see a "Sensors" entry in the top menu of Clowder, alongside "Help".

...

...