agreed, good find with that import/export feature, didn’t think to check for that since I don’t use tandoor. personally I’d just use the native import/export feature though since it feels less hacky than copying the whole DB imo. but if OP still wants to copy the files over, it might be easier to either just tar or tar + gzip rather than tar + zip so they can do it all in one command.
you’re probably right about it being a permissions error but also including some relevant logs would be useful (or just stick all of them on pastebin or something and give us a link). could also be a docker misconfiguration considering it’s a different system and I assume they’re not identically set up with Ansible or something similar
edit: also id personally use tar because I’m not entirely sure zip files preserve linux permissions
edit again: from 2 seconds of google searches, I think I’m correct about that, so definitely try using tar
honestly I don’t think it’s really a significant issue but if you’re worried just use a fs that can repair itself like zfs (not sure if btrfs can do that too but it might)
but the devs of these popular reddit apps likely have recycled a tonnn of their reddit app’s code into the Lemmy app and and are therefore working with a much more mature codebase that they’re also much more comfortable with. for example, I’m loving liftoff but it has so many random bugs that, while not awful, are a bit jarring. and the vast majority of them aren’t Lemmy bugs, they’re just normal app bugs that haven’t been worked out yet. and while I’m sure the liftoff devs are great, it’s a new app and will experience growing pains that sync likely won’t deal with as much.
for anyone who comes across this comment some day later when it’s expired, I think this link should stay updated: https://todo.syncforreddit.com/
also thanks! I’ve been looking for the link too
sorry! didn’t get a notification for this. but I’m liking lemm.ee because the instance is extremely well run and hasn’t had any noticable downtime or performance issues I’ve noticed with others. the person who runs it seems to really know what they’re doing and IIRC they’re a Lemmy dev.
“alternatively obtained” is funny but yea I completely agree. also makes the project description much less clunky sounding and more descriptive.
best time to make that decision is the present. personally I just transferred over my subscriptions and deleted the account of the previous instance I was on. it didn’t take much time.
I checked out your edit and what’s going on is pretty weird. my recommendation (if you don’t wanna just use the native import/export feature and give up on DB dumps) is to (on the new server) create a minimal tandoor docker-compose.yml, run it, do minimal setup, see if it works, and if the fresh container works, check the permissions, then just replicate those perms for your other postgres directory that contains data you actually care about. good luck!