Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Confluence database sequences different from Oracle to PostgreSQL

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?

2 answers

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.



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.

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

Petr Vaníček Community Leader Jun 05, 2019

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"? 

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

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

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

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

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

Suggest an answer

Log in or Sign up to answer
Community showcase
Published in Confluence

You’re invited: Confluence for MS Teams Live demo + Q&A

This past summer, we joined forces with Microsoft Teams as a part of our mission to help your team collaborate better, starting with more effective meetings. We released a new and improved Confluence...

82 views 0 1
Read article

Community Events

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

Events near you