Move Jira to a new server / postgresql 10

[Dani Kaplan]

Hi, 

I've updated jira and bitbucket to the latest version,

now I'm ready to move them both to a new server.

How should I do it - while keeping the links between them ? 

Also - I want to use postgresql 10 on the new server - is it possible ? 

Thanks, 

Dani

[Petr Vaníček · Accepted solution]

Hi Dani,

we are running Jira, Confluence and Bitbucket (in Data Center edistions) on PostgreSQL 10 without problems for last 2~3 months. But still it's not in supported platforms so keep it in your mind.

Migration is not big deal and it's not so hard.

1. Stop your applications
2. Dump databases
3. Recover databases into new PSQL 10 DB server
4. Copy INSTALL and DATA folders of your applications to new server with same permissions (and ideally to same locations)
5. Change DB details (if it is different) in dbconfig.xml (for Jira) and bitbucket.properties (for BB) 
6. Copy or add init script and try start it with live watching of logs with "tail -f"
7. Do reindex and in Jira run also Integrity checker
8. If everything is ok - then it's done :-)

[Dani Kaplan]

Thank you for the accurate answer. 

Can you elaborate more on the 6th step- 

how do I make them auto-restart and what do you mean with tail -f ?

Thanks

[Petr Vaníček]

Step 6 depends on your operating system. If you are running on OS with systemd and on your old server starting you apps automatically after boot then copy init script from old server to new one (for example /etc/systemd/system/jira.service)

You can get inspiration from this: https://confluence.atlassian.com/confkb/run-confluence-as-a-systemd-service-on-linux-937177781.html

With "tail -f" I mean live watching of logs for error or warning which can indicate some problem like this one "tail -f /opt/atlassian/jira/jira-install-7/logs/catalina.out". 

[Ahmed Hassan]

Hi Petr ,

can you please tell me for step 3 you used XML import/export or you used native DB tool , pg_dump & pg_restore? I'm having hard time to migrate confluence from psql 9.3 to 10

which confluence version you are using and which psql JDBC driver version?

Regards,

Hassan

[Rodrigo Cortez]

Atlassian will start working on adding PostgreSQL 10 support for Jira Server in the near future and will be reflecting the status on JRASERVER-65910.

Please join there, vote for it and set yourself as a watcher.  You'll receive an update there on our progress going forward.

We've also planned adding support for PostgreSQL 11. See JRASERVER-68578 for updates.

[Mahesh S]

Migrate both separately and then establish the integration. For latest jira 7.9, postgres versions till 9.6 is supported.

https://confluence.atlassian.com/adminjiraserver/supported-platforms-938846830.html

Logically, this doesnt mean that 9.10 isn't supported on latest jira but its not tested by the Atlassian team