Riven WikiManagement Commands
Database management and maintenance commands for Riven
Management Commands
Resetting the Database
To reset the Postgres database by dropping and recreating the riven table, you can use the following commands:
This will cause all of the data in your database to be lost. To include metadata, scraped times, and other data that's needed to run Riven.
Make sure you have the postgres container running, and you should docker stop riven before running the following commands.
docker exec -it postgres psql -U postgres -c "DROP DATABASE IF EXISTS riven;"
docker exec -it postgres psql -U postgres -c "CREATE DATABASE riven;"Set the HARD_RESET environment variable to true in your .env or docker-compose.yml file.
HARD_RESET=trueThen, restart Riven. Be sure to set HARD_RESET back to false after the reset is complete.
Make sure you have the postgres container running, before running the following commands.
rm -rf data/alembic/
poetry run python src/main.py --hard_reset_dbAfter the database is reset, upon restarting Riven, we will load back in the symlinks and re-index your library.
Resetting the Subtitles Database
To reset the Subtitles database by deleting the subliminal.dbm* files, you can use the following command:
rm -r data/subliminal.dbm*This needs to point to the data directory that the settings.json file is located in.
This will delete all of your Subtitles database files, and you will lose all your Subtitles.
This is not necessary and only needed if you're experiencing issues with the Subtitles specifically.
Trigger Symlink Repair
To trigger a symlink repair, you can use one of the following methods:
poetry run python ./src/main.py --fix_symlinksSet the FIX_SYMLINKS environment variable to true in your .env file.
FIX_SYMLINKS=trueThen, restart Riven. Be sure to set FIX_SYMLINKS back to false after the repair is complete.
Alternatively, you can also set the symlink repair option from the Riven settings, and just lower the interval to 1 hour.