Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
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

DB Transfer from prod to dev



I am attempting a refresh of our Dev Jira environment by importing a DB dump, created from the production DB via a pg_dumpall call.

I have imported this DB over our Dev environment by running /usr/pgsql-11/bin/psql -p 5434 -d postgres -f pg_dumpall.20211027.

The application on the application server was stopped before this import, and restarted after it.

However, some projects that are present in production, are missing from the Dev environment after this import.

Is there a different process I should or could use to achieve this? Do I need to copy any other directories from the DB or application server, from prod to dev? I found some articles suggesting copying the home directory, but I didn't see anything official from Atlassian in those threads as to whether that was safe, needed, or what the process should be for it.

In short, can you please advise how we should refresh our dev environment with the latest content from prod?

I asked this question to Atlassian support but they weren't able to offer any specific advice other than telling me to use our DB's native tools, which is exactly what doesn't seem to be working.



1 answer

0 votes

Did you

  • Have the target test Jira completely shut down while restoring the database?
  • Synchronise the attachments (not essential, the test system will simply show "not found" if files are missing)
  • Run a full locking re-index on test after restoring and restarting it?

My guess is the third - your database has all the issues, but the index is out of date.


The application on the application server was stopped while the DB was imported to the DB server.
I have not synchronised attachments, however an entire project is missing in the Dev environment, so if this is a problem, I think it's a bridge to cross later.
I have just now run a full re-index on the Dev environment. The new project is still not present.

Thanks for your help! Do you have any other suggestions?


Suggest an answer

Log in or Sign up to answer
Community showcase
Published in Jira

Do you use Jira Cloud with Microsoft Teams?

Hi, Jira users! Do you use Jira alongside Microsoft Teams? We want to hear how you’ve used the power of Jira Cloud and Microsoft Teams (via the Jira Cloud for Microsoft Teams app) to achieve a team...

54 views 0 3
Read article

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