1. What is the issue? Please be detailed. We performed an upgrade following the docs . We go to the steps of upgrading the database (we use the default) and there were no errors present. During the step to migrate postgres > postgres14 (docker compose up postgres) we got the following response: ubu…

Did anything unusual happen doing the upgrade or did it work step-by-step exactly as written in docs? Did the docker compose build before this step you showed have information about a database upgrade happening? Does ls ./files/postgres14/upgrade/upgrade-successful show that the file has been crea…

All the steps we took returned usual responses- no errors that we found. We did get the `upgrade-successful file as well. Gist for docker build: https://gist.github.com/dakotabenjamin/b9f37cc5dc2f9825f474ae327d44efc7- I don't see anything wrong per se but nothing about a db upgrade happening. Unfor…

I guess i read somewhere that for versions below 1.3, its better to do upgrade in 2 steps. First from 1.x to 1.5, and then 1.5 to 2023.x. when u restore your server from backup, try this.

Update: After much effort (we had a separate issue of a borked backup using the API, luckily we took a pg_dump as well) we managed to restore the original 1.2 server. From there, we did the following steps to work towards an updated solution: Created a fresh backup using pg_dump directory format …

Everything was going good until the big upgrade: odk-central-postgres-1 | Performing Upgrade odk-central-postgres-1 | ------------------ odk-central-postgres-1 | Analyzing all rows in the new cluster ok odk-central-postgres-1 | Freezing all rows in the new cluster …

I'm sorry you've had an unpleasant experience self-hosting, @dakotabenjamin , and I appreciate you documenting what worked and what did not so others can benefit. In general, you can skip upgrades and directly install the latest version as long as you follow all relevant upgrade instructions (e.g., …

ODK Forum

Upgrade from 1.2 to 2023.2 did not migrate database corectly

Support

odk-central

show post in topic

Home
Categories
Guidelines
Terms of Service
Privacy Policy

Powered by Discourse, best viewed with JavaScript enabled

Looking for a better way? Try ODK Cloud, the official managed hosting service from the creators of ODK.