Howto in case of upgrade ERROR: relation "cost_object_journals_pkey" does not exist"

[luckow]

If you use OpenProject and the update throws an error, follow this short howto:

• enable recovery mode for the app
• open the terminal
• switch to postgres
• have a look at the Indexes

\d+ cost_object_journals

• write down your "idx_12345_primary" key
• alter the index

ALTER INDEX "idx_12345_primary" RENAME TO "cost_object_pkey";

• open a second terminal and do a manual migration

./start.sh

• disable recovery mode and restart the app.

Done.

[robi]

Thank you for sharing.

There's a lot to unpack there, especially the postgres stuff.
I can see how many users wouldn't know what to do there.

Can you expand on all those 'postgres' parts and what to look for?

The 'manual migration' may not be needed since the app will do that on restart exiting recovery mode.