Page History

...

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

   • createdb geostream

   • psql geostream

   • CREATE ROLE clowder;

   • \c geostream;

   • CREATE EXTENSION Postgis;

     


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

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

   • psql -d geostream -f ~/geostream.sql;

     


4. 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. 

   1. Or you can add the following in Clowder to custom/custom.conf:

      postgres.user=clowder

      postgres.password=clowder

       

5. Enable Postgres plugin in Clowder by adding the following to clowder/custom/play.plugins:
   • 10502:services.PostgresPlugin



...