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; } } }

Migrate SQL to PostgreSQL

Raj_0ch8lz

Hi All,

I am new to Jira and current Jira DC version 8.20.8 we are using with SQL 2019. Current application servers are setup using archive (TAR) file.

Now we are planning to migrate to new servers including app and database (migration to PostgreSQL). Is it ok to setup new app servers with "Install Jira using an installer" option?

Also what is the best way to migrate to PostgreSQL and to new app servers? Thanks in advance.

Accepted answers

Fabio Racobaldo _Catworkx_

Hi @Raj ,

here an useful how-to guide for that https://confluence.atlassian.com/adminjiraserver/migrating-jira-applications-to-another-server-938846962.html

Hope this helps,

Fabio

Dirk Ronsmans

Hey @Raj ,

In addition to @Fabio Racobaldo _Catworkx_ 's documentation this should help you out too

https://confluence.atlassian.com/adminjiraserver/switching-databases-938846867.html

In short you'll have to set up a new DB on the new technology and then perform an XML backup/restore within Jira (as there is no way to convert between database technologies directly)

All comments

Fabio Racobaldo _Catworkx_

Hi @Raj ,

here an useful how-to guide for that https://confluence.atlassian.com/adminjiraserver/migrating-jira-applications-to-another-server-938846962.html

Hope this helps,

Fabio

Dirk Ronsmans

Hey @Raj ,

In addition to @Fabio Racobaldo _Catworkx_ 's documentation this should help you out too

https://confluence.atlassian.com/adminjiraserver/switching-databases-938846867.html

In short you'll have to set up a new DB on the new technology and then perform an XML backup/restore within Jira (as there is no way to convert between database technologies directly)

Raj_0ch8lz

Thanks @Fabio Racobaldo _Catworkx_

Raj_0ch8lz

Thanks @Dirk Ronsmans . This means no action on database side. Just setup new DB technology and do a XML restore in Jira (Update dbconfig.xml with new db connection name) right?

Fabio Racobaldo _Catworkx_

You're welcome @Raj

Dirk Ronsmans

correct!

Raj_0ch8lz

Also current app servers are setup using Archive file (TAR).. Can i setup my new servers with Installer mode... or it has to be setup in same mode for XML backup/restore to work?

Welcome!

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

Quick Links

Find more posts tagged with

server

jira-software

jira-software-server