We have tried creating a new app via snapshots, but these new apps will also not move to a new org.
There is lots of topics with similar issues and no real solutions, can someone share a solution to move a PG app to a new org please?
When trying to fork in the same org in the hopes that the new app will actually migrate we get these errors:
failed post-init: failed to enable repmgr: failed to create repmgr database: ERROR: template database "template1" has a collation version mismatch (SQLSTATE XX000). Retrying...
Edit:
I have tried absolutely everything possible to create a clone of the current PG app by creating from snapshot or trying to create from a fork, nothing will result in a healthy new app. Nothing works.
We have now tried to use remote backups - this also fails with no helpful error messages…
fly pg backups create --name move-to-scratch --app rotator-api-db
Exit code: 1
Performing backup...
failed to create backup: signal: killed
Error: failed to create backup: signal: killed
This suggestion / solution (Moving postgres app to another org - #2 by flyandre) makes no sense, you can’t access snapshots across orgs…?