Confluence database sequences different from Oracle to PostgreSQL

[Daniel Alonso]

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?

[JP _AC Bielefeld Leader_]

Do a backup from within Confluence & import the backup on a new server using the new database.

There is no migration path by using any database conversion / migration tools.

Best

JP

[Dave Theodore [Coyote Creek Consulting]]

Agreed. Your best bet is to use the XML backup from your current instance and import it in to a new instance connected to the Postgres DB.

[Daniel Alonso]

XML backup was not an option because the instance is huge, that's why we use the oa2pg alternative.

[Petr Vaníček]

I'm afraid you don't have any other way except what wrote @JP _AC Bielefeld Leader_ based on all what you already tried. What you mean as "huge"? 

[Daniel Alonso]

Finally we could figure it out, I will write an article about it and share it here with you soon.

[david kreuter]

Currently I'm facing the same issue. Did you find time to write the article?

[Daniel Alonso]

@david kreuternot yet, but I can provide the complete solution, just put in contact with us on the page: https://trundl.com/ to discuss about it.

[Sachin]

@Daniel Alonso - did you publish the article for this?

[Pedram M]

Facing this issue now. Can I get a link to the article?