Playing with the database

Database migrations

A gradle task is available for all migrations. Make sure you have set up a working database first. For that, see getting started

Exporting the database

To create a dump that can be quickly restored use the following command:

pg_dump -U telraam_user -d telraam_dev --inserts --rows-per-insert=2000 -Ft -f dump.sql

Restoring can be done with (Make sure you work with a clean database):

pg_restore -U telraam_user -d telraam_dev dump.sql --disable-triggers