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):

seq_oracle.png

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:

seq_psql.png

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

4 votes

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

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: https://trundl.com/ to discuss about it.

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Posted in Confluence

How is your team having fun and bonding, remotely, utilizing Confluence?

Thanks everyone for answering last week’s question. The winner of the random drawing from those who commented is: @LarryBrock I’ll contact you separately with your prize details. This wee...

283 views 9 7
Join discussion

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