Create Kylo Database and User

If you prefer to run Kylo as a non-privileged user and want to create the database schema yourself please do the following.

Note

These commands need to be ran as a database administrator

Create the kylo database

This must be done as a database administrator

Postgres

$ sudo -u postgres psql

> CREATE DATABASE kylo;

Create the kylo database user

Postgres

$ sudo -u postgres psql

> CREATE USER kylo WITH PASSWORD 'abc123';

Grant Kylo user access to DB

Postgres

$ sudo -u postgres psql -d kylo

> grant usage on schema public to kylo;
> GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA PUBLIC TO kylo;
> GRANT ALL PRIVILEGES ON ALL SEQUENCES IN SCHEMA PUBLIC TO kylo;
> grant execute on all functions in schema public to kylo;
> alter default privileges in schema public grant execute on functions to kylo;