Created a new version of KoboToolbox and plan to attach my old Vols backup

Hi team @Kal_Lam @jnm @stephenoduor @ks_1

I have created a new version of KoboToolbox and plan to attach my old Vols backup (from the 2019 version of KoboToolbox) to the new installation. However, my database username and password have changed, and I’ve encountered some issues. Could you please provide your valuable guidance?

@Rejeesh, pinging @stephenoduor and @ks_1 for your support here.

Hi @Kal_Lam @stephenoduor @ks_1

“I have observed significant structural differences between the old and new database versions, with the newer version containing more tables. Due to these changes, I cannot directly restore a dump from the old database to the new one. My plan is to upgrade the existing database first, then take a dump from the upgraded version and restore it to the new database.”

I believe the old version of .vols or the database might not be supported in the new version of KoboToolbox. Could you please confirm if my approach is correct? If not, I would appreciate your guidance on how to properly upgrade the system. Do you have any documentation or knowledge that you could share with me to help ensure a smooth upgrade?

Hi, @Rejeesh , you cannot upgrade direct since your instance is older than 2.022.44

You have to follow the [upgrade process] as is, (kobo-docker/doc/November-2022-Upgrade.md at master · kobotoolbox/kobo-docker · GitHub),

1 Like

HI @stephenoduor Thanks for giving this document.

I have followed the suggested steps to upgrade PostgreSQL and have also completed the MongoDB upgrade. Everything is working, and the database has been upgraded without any bugs. The final step is to run Python 3, but I am encountering a runtime error. What could be the issue, and how can I resolve it?Could you please provide your valuable guidance?

Hi @Kal_Lam @stephenoduor @ks_1

Do you have any solutions for the above issue? Please give me them.

Hi team @Kal_Lam @stephenoduor @ks_1 @stephanealoo I am still facing this issue so I have to take step by step to update PostgreSQL. After updating its dumb file, take and test the local machine using the new Kobotollbox version. Repeat the same step for the other database to ensure its method is correct. Do you know of another method? Could you please provide your valuable guidance?