Migrate jira datebase on same server

[Sean Dunaj]

I did an install using MySQL and now rethinking it I want to swap it to POSTGRESQL. Can i migrate a database on the same server or do I need to stand up another instance and migrate to that then migrate it back? There is not that much data in the database but I'd rather not have the users have to recreate what's there.

-thanks in advance

sean

[Alexis Robert · Accepted solution]

Hi @Sean Dunaj , 

yes it's possible to migrate databases on the same server : if you have data on your Jira instance, you will first need to do a XML backup and then reimport it on your PostgreSQL database. 

You can follow the documentation here : https://confluence.atlassian.com/adminjiraserver/switching-databases-938846867.html

Let me know if you have any questions, 

--Alexis