...
- Install Postgres
- Create necessary database & roles in Postgres command-line
createdb geostream
psql geostream
CREATE ROLE clowder;
ALTER ROLE clowder with LOGIN;
ALTER ROLE clowder with password 'clowder'
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.
Or you can add the following in Clowder to custom/custom.conf:
postgres.user=clowder
postgres.password=clowder
- Enable Postgres plugin in Clowder by adding the following to
clowder/custom/play.plugins:
10502:services.PostgresPlugin
...