It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

How to restore JIRA from a full database backup?

Per many recommendations (including Atlassian's) I have been backing up my JIRA instance using:

  1. A full native DB backup (`pg_dumpall` for postgres in my case)
  2. A snapshot of the JIRA data dir

Now I am trying to actually do a restore to a brand new server (the old one is gone) and am having trouble getting it to work.

First, when I fully restore the database in advance of the JIRA installation, JIRA does not recognize the existing data at all and goes though the process of a fresh DB creation. When the installation is complete, the data is definitely not in JIRA... presumably because JIRA altered the restored database (but I didn't dig into this).

Next I did afew variations of the following:

  1. Stop JIRA
  2. Drop the JIRA DB
  3. Re-run the postgres restore script (`psql -f pg_backup_file postgres` as user postgres)
  4. Stop and restart PostgreSQL (for good measure)
  5. Restore the JIRA data dir snapshot
  6. Ensure the DB connection works properly for JIRA
    • (I had to change the user password, so I fix DB connectivity by either altering `dbconfig.xml` directly and/or changing/testing with ``)
  7. Restart JIRA
  8. Connect to my JIRA URL

When I do this, JIRA still does not recognize any of the restored project data. I can log in successfully to JIRA, but he project list is empty.

What is the correct way to restore JIRA from a full database backup?

0 answers

Suggest an answer

Log in or Sign up to answer

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you