Hi,
We are recently upgraded bitbucket to version Atlassian Bitbucket v5.11.1 in our Production environment and now getting WARNING that "Support for PostgreSQL 9.2.24 has been deprecated and will be removed in an upcoming release. You should migrate to a supported database."
I tried to upgrade postgreSQL earlier using following steps but it broke all of our Repos and LDAP integration so I somehow managed to revert the changes and it was back to the previous stage.
Steps I followed to upgrade PostgreSQL:
==============================================
1. Install the repo RPM for PosgresSQL 10
sudo yum install https://download.postgresql.org/pub/repos/yum/10/redhat/rhel-7-x86_64/pgdg-centos10-10-1.noarch.rpm
2. Install PosgreSQL 10
sudo yum install postgresql10-server
3. Stop Postgresql 9.2 and Postgresql 10
sudo systemctl stop postgresql.service
sudo systemctl stop postgresql-10.service
mv /var/lib/postgres /var/lib/postgres.old
mv /var/lib/pgsql /var/lib/pgsql.old
4. Initialize the PostgreSQL 10 database
sudo su postgres
cd ~/
/usr/pgsql-10/bin/initdb -D /var/lib/pgsql/10/data/
5. Migrate your database from the 9.x version to 10
/usr/pgsql-10/bin/pg_upgrade --old-datadir /var/lib/pgsql.old/data --new-datadir /var/lib/pgsql/10/data/ --old-bindir /usr/pgsql-9.5/bin --new-bindir /usr/pgsql-10/bin/
6. update file--
/var/lib/pgsql/10/data/postgresql.conf
#listen_addresses = 'localhost'
7. update file--
/var/lib/pgsql/10/data/pg_hba.conf
8. Start the server
systemctl start postgresql-10.service
systemctl enable postgresql-10
9. Remove PostgreSQL 9.x and its data
sudo yum remove postgresql-server.x86_64
sudo yum remove postgresql95-server
=======================================
Can somebody please suggest how can we upgrade PostgreSQL without breaking anything?
Thanks,
Nitesh
niteshsinghal88@hotmail.com
