How to backup and restore Exalate's configuration in Jira?

General Questions
, , , ,
1

Originally asked by Alain Lompo on 23 October 2020 (original question)

The Problem:

We have a Jira instance with Exalate installed there. We use it to synchronize issues between two remote Jira instances.

We have another Jira instance from which we get regularly some backup datas. This backup is restored in the above mentionned instance. However the backup does not have Exalate. Therefore after the restoration, the Exalate configuration is lost.

How we backup and restore Exalate configuration so that we Can apply that restoration after the General restore has finished running.

The Options we have been thinking About:

  • Create Backup Restore SQL scripts
  • Reverse engineer the backup file to directly include Exalate configuration informations

Both Options seem risky to me, so any other Suggestion is welcome and will be seriously considered.

2

Answer by Francis Martens (Exalate) on 23 October 2020

Ah - that is a good question.
What type of database do you have?

Comments:

Alain Lompo commented on 23 October 2020

We are using Postgres 9.6

Francis Martens (Exalate) commented on 23 October 2020

Hi Alain Lompo

I created a small script to dump all the exalate related tables from a postgres which is running in container.

Check the code here

Note that this list contains a couple of tables which are related to the upcoming release of the visual script rule editor - so you might have to skip them.

By creating the dump sql, you can then import it into your other environment

Let me know if it helps

Francis

Alain Lompo commented on 23 October 2020

Thank you Francis. I will look into it.

Alain Lompo commented on 04 November 2020

Francis, I have used the script that you have provided and I have also built a second one to restore the tables in the target instance. Build and restore are working fine, nevertheless the plugin does not appear as installed in my Jira instance in the “App Management” section.

In my opinion there must be some additionnal metadatas that should be also similarly imported. There is probably an extra configuration tables through which Jira administrates the plugins and there statuses (installed, deinstalled, deleted, …). What do you think about it?

Francis Martens (Exalate) commented on 05 November 2020

Is the add-on available on the configuration?

Alain Lompo commented on 05 November 2020

I have not understood your question. Do you mean do I see the add-on infos in the backups? Yes. Or I am backup-ing from an instance where the add-on is installed and configured? yes.

Francis Martens (Exalate) commented on 05 November 2020

From your comment, I reckon that the addon is not visible in the manage apps section.
Is this correct?