Migrate to v2

Migrate to v2#

From version 2, users and profiles are stored in a PostgresQL databases.

Before migrate to version 2, you MUST checkout the latest 1.x.x release and run all migrations of this last release.

Create a database with the schema#

Docker#

If you use the docker-compose.yml file from the souslesens/souslesensVocable repository, a PostgresQL server is included.

Be sure the following variables are set in .env file:

  • POSTGRES_PASSWORD

  • DATABASE_USER

  • DATABASE_NAME

  • DATABASE_PASSWORD

Execute the init script manually:

docker compose exec -u postgres postgres "/docker-entrypoint-initdb.d/init-db.sh"

The script will create the database with the application role and the schema.

Non-docker#

Create a database and a role.

Then, exectue the scripts on the scripts/sql directory.

Migrate the data#

Run the migration script with npm run migrate to migrate data from the config/users/users.json and the config/profiles.json. The migration will keep the file. You have to delete it manually.