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

JIRA OnDemand : Can we get a PostgreSQL dump?

Clark Evans

For your on-demand service, is there anyway we could get a periodic PostgreSQL backup dump of the data set? We'd like to run SQL based reports using your schema, and, it seems re-creating your schema via the XML data file might be tedious. We're thinking having a pg_dump might be much simpler.

Accepted answers

All comments

Nic Brough -Adaptavist-

No. Access to the database isn't granted as part of OnDemand/Cloud, and providing dumps isn't standard procedure. (Atlassian might well do it on a support request, but you'll need to make a new request each time you want it, they won't do it often, and it could take a few days as a low-priority task)

If you want a download of all your data, use the "backup" feature which will dump everything to a standard Jira xml backup which you can load into a local Jira any time you want. You can do this daily.

Clark Evans

Then, I guess, my request is that they might include the PostgreSQL dump as an option of their backup feature.

Lacking that, how would I convert a standard backup into a PostgreSQL database? Is there any sort of software you can download to do that?

Nic Brough -Adaptavist-

I very much doubt it will happen, you've got access to XML which you can import into any database you want, why bother with a dedicated dump.

To import it, set up a dev/test Jira, point it at an empty database of your choice, and run the installation procedure, choosing "I have an xml backup" and pointing it at the file you downloaded.

No fuss, no manipulations, no hassle of database fiddling, you start clean and import it. Once you've imported once, you can leave the dev/test transfer system in place and next time you need it, just import the new file from "Import" in the admin GUI

Diego Zarpelon

Hey Clark.

You can use that backup to create a local JIRA instance with it, as said by Nic, using this guide.

Welcome!

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

Quick Links

Find more posts tagged with

jira-cloud

backup

postgres