Hello, I know this question comes up here periodically, but I am having some trouble performing a data migration from an older version of mailman3 to a more recent one.
We have a legacy environment with: mailman3.2.2 postorius 1.2.4 hyperkitty 1.2.2 there are two sqlite3 dbs for mailman core and mailman web.
I've staged a new environment using the docker-mailman project with the following:
mailman3.3.9 postorius 1.3.10 hyperkitty 1.3.8 there is a single postgres db here for both core and web.
I've tried migration a few different ways, using pgloader, and also with some manual python scripts. Data is definitely not my forte, but I am struggling to get a working instance. I am running into several issues such as foreignkeyviolations, datatype mismatches, unique PK errors, etc..
Does anyone out there have a prescriptive process for this migration, or a suggestion for workflow/tooling that has worked in a similar upgrade process?
Thanks! -Peter