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.
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