Configure a database

Configure a database

Kadeck requires a database for storing information. An external database such as H2 or PostgreSQL is recommended in a production environment.
If no external database information is supplied, Kadeck will use an internal H2 file-based database. This is not recommended for production use as all data is lost after a container restart. 

Supported databases

Kadeck currently supports:
  1. PostgreSQL Database
  2. H2 database

Configuring the database connection

The database connection details are passed to Kadeck as environment variables in the form of a JDBC connection string.
Example (with Postgres database):
  1. xeotek_kadeck_db_url=jdbc:postgresql://kadeckweb.eu-central-1.rds.amazonaws.com:5432/kadeckweb
Although username and password can be specified in the JDBC string, the username and password can alternatively be specified using the following environment variables:

  1. xeotek_kadeck_db_username=my_user
  2. xeotek_kadeck_db_password=my_password
User permissions
The configured database user must be able to create tables and read/write data.

Database size

A recommended size for the database to start with is 1GB. Depending on the usage and the growing audit logs, the size of the database must be increased.