Upgrading psql 9.1 to 9.6 for Bamboo upgrade

My Bamboo server was made into a monstrosity by its' previous admins and I now have to work to automate the process and clean it up.

To fix the ailing beast I need to upgrade psql 9.1 to 9.6 and retain all the present data in the database.

I will need to know how to export the data from psql 9.1 (which I believe I have now completed) as well as how to import the data into 9.6 such that bamboo can use the new database as the old one.

3 comments

You should be able to use the standard dump/restore mechanism of Postgres. Then just point Bamboo to the new database via bamboo.cfg.xml and you're good to go.

Hello,

standart mechanism is

https://www.postgresql.org/docs/9.1/static/backup-dump.html

You must have access to PostgreSQL and created folder with read/write permissions on OS.

Then for example:

    Export - pg_dump -U userdb namedb -f namefile.sql
    Import - psql -h localhost -U userdb -d namedb -f namefile.sql

After you configure bamboo.cfg.xml to new PostgreSQL and database.

https://confluence.atlassian.com/bamboo/changing-bamboo-database-settings-289277406.html

Comment

Log in or Sign up to comment
How to earn badges on the Atlassian Community

How to earn badges on the Atlassian Community

Badges are a great way to show off community activity, whether you’re a newbie or a Champion.

Learn more
Community showcase
Published May 18, 2017 in Bamboo

FAQ: How to Upgrade Bamboo Server

Bamboo 5.9 will no longer be supported after June 12, 2017. What does this mean? As part of our End of Life policy, Atlassian supports major versions for two years after the first major iteratio...

1,581 views 0 6
Read article

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you