Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  1. Install Postgres

  2. 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;


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

  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

...