nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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?

Accepted answers

All comments

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

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_ei4vlr

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

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

confluence

server

confluence-server

oracle

postgres