nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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

Accepted answers

Petr Vaníček

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.

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

All comments

Mahesh S_y9hwt0

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

Petr Vaníček

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.

Stop your applications
Dump databases
Recover databases into new PSQL 10 DB server
Copy INSTALL and DATA folders of your applications to new server with same permissions (and ideally to same locations)
Change DB details (if it is different) in dbconfig.xml (for Jira) and bitbucket.properties (for BB)
Copy or add init script and try start it with live watching of logs with "tail -f"
Do reindex and in Jira run also Integrity checker
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_pqdp6g

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_jg22qq

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.

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

bitbucket

jira-software