Getting WARNING: Support for PostgreSQL 9.2.24 has been deprecated and will be removed in an upcomin

[Nitesh Kumar]

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

[Ana Retamal]

Hi, welcome to the Community! 

You can use the option 'Migrate database' in Bitbucket instead of migrating the data manually, more info at Connecting Bitbucket Server to PostgreSQL . We don't provide the guidelines on how to upgrade PostgreSQL, for details please check their official documentation at information https://www.postgresql.org/docs/.

Hope that helps!

Ana