DB Transfer from prod to dev

[Auto _ General Admin]

Hi,

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.

Thanks,
Benjamin.

[Peter T · Accepted solution]

There isn't a difference between a DL and individual email from JIRAs perspective. This is all handled by the receiving mail server.

If the email is not getting received I suggest you check the following:

• atlassian-jira.log in the home folder
• the outgoing and error mail queues

image2016-3-10 11:0:19.png

in case you see any related errors please post them here

Cheers,

Peter T

[Moon]

Thanks for your response Peter. Another piece of info is that our JIRA is integrated with outlook distribution lists (groups). But before a DL can be referenced within JIRA it needs to be added to JIRA first. I wonder if that is the case since I cannot see the DL from our Jira. I have asked our IT department to add it. 

[Peter T]

I think that is the case!

[Deleted user]

The "to addresses" field should be able to send email messages to any email it is configured to send it to, including distro list. Can you check the logs if there are any errors? Nested DLs is no exception here.

[Moon]

Thanks for your response. I made some comments in response to Peters feedback. 

[JamieA]

Double check you are using the SMTP address of the DL. I don't see why this wouldn't work. Maybe ask your exchange admins if it's being blocked, or if the user doesn't have permission to send to that DL.