You're on your way to the next level! Join the Kudos program to earn points and save your progress.
Level 1: Seed
25 / 150 points
Next: Root
1 badge earned
Challenges come and go, but your rewards stay with you. Do more to earn more!
What goes around comes around! Share the love by gifting kudos to your peers.
Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!
Join now to unlock these features and more
The Atlassian Community can help you and your team get more value out of Atlassian products and practices.
Hello.
OS: Ubuntu 20.04.3 LTS.
I try to migrate Confluence to another server. I had backuped confluence install directory and application-data. On production Confluence I made a xml-backup file - all OK, no errors.
Note: Prodaction Confluence on MySQL 5.7 version. I need migrate to PostgresQL 11 - how I understand psql 11 - latest supported DB.
On new server, I installed PostgresQL 11 and Confluence from .bin-file same version as a Prod (7.12.4). Created DB with ENCODING 'UTF-8' LC_COLLATE 'ru_RU.UTF-8' LC_CTYPE 'ru_RU.UTF-8' for correct Russian support. Created Confluence DB user and granted all to new DB.
Then I copy Confluence HOME and APP-DATA directories from Prod to new Server - all OK, no errors.
On step, when I need to restore Confluence from xml backup file - I put xml.zip backup to /app-data/confluence/restore directory - new Confluence see that file, restored - OK.
But, I cant login and there is no data! In PostgresQL terminal - new Confluence DB size - 37 MB. In Prod MySQL db size - 1,5GB.
What that and how to fix that issue?
P.S. By same steps I had migrated Jira - database and data recovered from Jira xml backup file. There was no errors to import data to PostgresQL DB.