Papercuts trying to move an app + db between personal account & organization

[isaacparrot]

Hey there

I just wanted to share a little issue I had with the platform.

After prototyping an application in my personal account, I decided to create an organization and move the resources to give access to a friend.

After first moving the web application to the new account, I was surprised that the DB didn’t seem to move over after a few attempts. It turns out I was missing the message in the logs telling me this isn’t supported for Postgres at the moment – something some other posts here seem to mention.

Once I realized this wouldn’t be a trivial migration, I decided to migrate the application back to my personal account. Unfortunately, this didn’t appear to be possible from the UI! After starting a move, I would get an error with the message ‘Organization isaac-parker not found’.

In the end I modified the flyctl commands and got things working. Using flyctl apps move appnamehere–without any flags–will let you choose an organization from the list, including a “Personal” organization.

I’m not sure where else to document this, but hopefully this can be a hint for someone else stuck or a start of a bug report if this little trap isn’t known.

[mayailurus]

Yikes, glad you eventually got it back to a stable state, at least…

Was this Managed Postgres or Legacy Postgres?

(The latter will unfortunately tend to mostly be paper cuts and the occasional data-rescue emergency, as it gradually gets more and more deprecated…)