Upgrading psql 9.1 to 9.6 for Bamboo upgrade

admin admin
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
July 1, 2017

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

Przemek Bruski
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
July 1, 2017

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.

Moro support for AEVI August 3, 2017

Hello

MoroSystems Support
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
August 3, 2017

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
TAGS
AUG Leaders

Atlassian Community Events