Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,300,104
Community Members
 
Community Events
165
Community Groups

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
TAGS
Community showcase
Published in Bamboo

Bamboo Data Center on Kubernetes

Hi, If you are running self-managed environments and looking to adopt modern infrastructure, Bamboo Data Center can now be deployed in a Kubernetes cluster. By leveraging Kubernetes, you can easily...

967 views 3 8
Read article

Community Events

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

Find an event

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

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you