I'm doing a database migration from Oracle to PostgreSQL, using the ora2pg tool, and there were some errors with sequences, so I started researching why if all the sequences looked to be the same as they were in Oracle...
Then, I installed a fresh instance of Confluence in PostgreSQL and installed all the Apps to see the name of the AO tables.
I noticed that sequences have different names compared Oracle vs PostgreSQL (Fresh instance):
In Oracle, the sequences for AO Tables (App tables) are ending with number, for example table for "Calendar Teams". In Postgres (Fresh instance), they have the full string name:
Is there a way to reset all the sequences on Confluence?
I already tried this:
1. Backup all the sequences
2. Delete the sequences
3. Delete the plugin folders
4. Restart Confluence
That didn't work, any suggestions?
- Create your own custom emoji 🔥 - "Shake for Feedback" on mobile 📱 - An endless supply of GIFs via GIPHY 🤩 Is there anything quite as nice as a pleasant surprise? Comment below with what...
Connect with like-minded Atlassian users at free events near you!Find an event
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.Host an event
You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events