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; } } }

What steps are necessary to upgrade my psql 9.5 database to psql 9.6?

Kyle Manel_m3mbr5

Or is the process as easy as exporting from 9.5 with;

pg_dump -U $DB_USER $DB_NAME > /tmp/db_name.pgsql

& importing into psql 9.6 with;

psql -U $DB_USER $DB_NAME < /tmp/db_name.pgsql

Accepted answers

Andrew Laden

This was discussed in this question, you may want to look at that first.

https://community.atlassian.com/t5/Jira-Software-questions/Upgrading-psql-9-5-to-9-6-for-Jira/qaq-p/1042686

But in general you should be able to dump and load, particularly between minor versions.

I was able to to do it as follows

Create database and users manually as user postgres

createdb -E utf8 jiradb

psql

create user jira with password '<LOOK IT UP>';

grant all privileges on database jiradb to jira;

Shut down Jira on old server
Take a dump of the existing database
1. pg_dump jiradb> jiradb.dump
Copy to new server
1. scp jiradb.dump newserver:/tmp
Connect to server as application user and load data
1. psql -U jira -h <new host> -p 5432 -W jiradb< /tmp/jiradb.dump
configure confluence to point to new database
1. /opt/atlassian/jira-data/dbconfig.xml
  1. <url>jdbc:postgresql://127.0.0.1:5432/jiradb</url>
start up Jira

All comments

DPKJ

@Kyle Manel May I know what OS are you on?

Andrew Laden

This was discussed in this question, you may want to look at that first.

https://community.atlassian.com/t5/Jira-Software-questions/Upgrading-psql-9-5-to-9-6-for-Jira/qaq-p/1042686

But in general you should be able to dump and load, particularly between minor versions.

I was able to to do it as follows

Create database and users manually as user postgres

createdb -E utf8 jiradb

psql

create user jira with password '<LOOK IT UP>';

grant all privileges on database jiradb to jira;

Shut down Jira on old server
Take a dump of the existing database
1. pg_dump jiradb> jiradb.dump
Copy to new server
1. scp jiradb.dump newserver:/tmp
Connect to server as application user and load data
1. psql -U jira -h <new host> -p 5432 -W jiradb< /tmp/jiradb.dump
configure confluence to point to new database
1. /opt/atlassian/jira-data/dbconfig.xml
  1. <url>jdbc:postgresql://127.0.0.1:5432/jiradb</url>
start up Jira

Kyle Manel_m3mbr5

Linux.

Kyle Manel_m3mbr5

Thanks for your assistance. I've been creating and testing on postgresql 9.5.20, but it will make sense soon, to move to a different primary version. I'll give this a go in the coming days and get back to you.

DPKJ

@Kyle ManelEach distribution have defined steps for upgrading Postgres without data loss.

I used this gist - https://gist.github.com/delameko/bd3aa2a54a15c50c723f0eef8f583a44 for Debian like distribution, and I had no loss of data.

Kyle Manel_m3mbr5

Which products (Jira, Confluence, Bamboo, Bitbucket, etc) did you move your data from psql 9.5 to 9.6 with?

DPKJ

@Kyle Manel for Jira and Confluence

Welcome!

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

Quick Links

Unanswered
Groups
Help

Find more posts tagged with

server

jira-software

jira-software-server