Migrating through PostgreSQL versions

[jbartlett86]

Hi,

I'm in the process of migrating my organisations JIRA Software instance to be containerised (using Kubernetes) and at the same time I will upgrade it from version 7.3.2 (very out of date) to 8.6.1 and at the same time move from PostgreSQL 9.6 to 10.

Based on my initial test attempts I know I need to start by importing the original instance data (7.3.2) into an the new instance on 7.13.11 (any higher and the import fails) and then migrate to 8.0.3 and then I can finally migrate up to 8.6.1.

This seems to have worked OK although I have a few questions/concerns I'm hoping people can help with.

1) I'm only using PostgreSQL 10 throughout this entire process even though the versions prior to 8.6 don't support 10 (this is because we currently only have a PostgreSQL 10 insance available). Now I haven't noticed any issues however it would be interesting to know what others normally do when they move through versions that support different database versions and whether anyone has attempted using just PostgreSQL 10 and have they experienced issues?

2) When moving to 8.6.1 we got an error screen regarding custom changes to files not being carried over... specifically bin/setenv.sh and atlassian-jira/WEB-ING/classes/entitydefs/entitymodel.xml. Is this a general error as I'm using the official atlassian jira software docker images so I wouldn't expect these files to be customised?

Thanks,

John

[Justin Shapiro]

Try going to Confluence Admin - > Scheduled Jobs and running the Populate CAS Map job