Additional data to delete when migrating Radarr's DB to Postgres
imjuzcy opened this issue · 1 comments
imjuzcy commented
In the instructions to migrate Radarr's sqlite DB to postgres, when making sure Radarr starts on the new postgres DB before migrating data, Radarr also writes to the tables "NamingConfig", "ScheduledTasks", and "VersionInfo".
The last two might now be that important, but "NamingConfig" is important to a lot of people if they have that set up. So the existing data in that table in the postgres DB should be cleared before migrating.
For the sake of completeness, I think all tables should be cleared before migrating, so the commands should be
DELETE FROM "Profiles";
DELETE FROM "QualityDefinitions";
DELETE FROM "DelayProfiles";
DELETE FROM "Metadata";
DELETE FROM "NamingConfig";
DELETE FROM "ScheduledTasks";
DELETE FROM "VersionInfo";
bakerboy448 commented
There is no need nor reason to clear all tables
Please visit the discord if you have Postgres questions.