Graphlytic uses an embedded backend database by default (HSQL DB). However, external PostgreSQL is also supported.
How to set up a PostgreSQL connection
Prerequisites:
The database needs to be already created. (Example script: “CREATE DATABASE graphlytic;”)
Graphlytic needs to be run with the GRAPHLYTIC_DATABASE_DIALECT=postgres variable
When all prerequisites are fulfilled, Graphlytic tries to connect to PostgreSQL with the default values. Default values can be modified with environment variables:
Parameter | Description | Default value for dialect postgres |
|---|---|---|
GRAPHLYTIC_DATABASE_DIALECT | Supported values are: | N/A |
GRAPHLYTIC_DATABASE_USERNAME | Username needed for database authentication. | postgres |
GRAPHLYTIC_DATABASE_PASSWORD | A password for the database authentication. | postgres |
GRAPHLYTIC_DATABASE_HOST | Database domain name with path (if applicable). | localhost |
GRAPHLYTIC_DATABASE_PORT | Database port. | 5432 |
GRAPHLYTIC_DATABASE_NAME | Database name. This database needs to be created manually before running graphlytic. | graphlytic |
GRAPHLYTIC_DATABASE_SCHEMA | Database Schema where Graphlytic metadata will be stored. | graphlytic |