...
- Install Postgres
- Create necessary database & roles in Postgres command-line
createdb geostream
psql
CREATE DATABASE geostream;
CREATE ROLE clowder;
\\c geostream;
CREATE EXTENSION Postgis;
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;
- 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.
- Enable Postgres plugin in Clowder by adding the following to
clowder/custom/play.plugins:
10502:services.PostgresPlugin
...