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 Join to comment
Community showcase
Renan Battaglin
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,097 views 0 5
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
Atlassian Team Tour

Join us on the Team Tour

We're bringing product updates and pro tips on teamwork to ten cities around the world.

Save your spot