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