Upgrading psql 9.1 to 9.6 for Bamboo upgrade

Question

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.

MoroSystems Support · Answer

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

Moro support for AEVI · Answer

Hello

Przemek Bruski · Answer

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.