Lightdash requires a PostgreSQL database (version 12 or greater).
Configuration options for external database
configMap
Required pg extensions for external database
Lightdash requires the following extensions to be installed on the database:uuid-ossp
- used for generating unique IDs
Migrations
Migrations are ran automatically on starting the Lightdash server or workers. When upgrading Lightdash, migrations will be ran automatically. If migrations fail due to a pg_lock error, check for a table calledknex_migrations_lock
to manually release the lock.