I saw this and thought “How is this even possible? No way you run an SSH server from initramfs…” Turns out that’s exactly how you do it, I’ll be trying this out thank you!

Ahhh thank you, by the looks of the thread you linked it seems that there’s no way of doing it without manually copying database tables over. I did think that may be the case, so I’ll just migrate it the normal way then. Thanks for the help!

That does seem like a good option for my use case, interestingly they note that no matter what I switch to I should change the subdomain:

It’s not supported across the Fediverse to switch between implementations on the same domain. This means that if you run GoToSocial on example.org, you’ll run into federation issues if you try to switch to a different implementation like Pleroma/Akkoma, Misskey/Calckey etc.

That doesn’t look promising for moving the account without migrating because then I couldn’t maintain my username.

Overall I think Alex handled this situation really well, listened to what people wanted and come to something that everyone’s fine with.