Problems Upgrading Postgres database 9.2 to 11

Mattermost Version: 5.25.2
Database Schema Version: 5.25.0
Database: postgres
postgres (PostgreSQL) 9.2.24
CentOS Linux release 7.9.2009 (Core)

Anyone upgraded their database from 9.2 to 11? I just tried and it’s brutal…

I grabbed the version of postgres from here -
https://www.postgresql.org/download/linux/redhat/

I found this medium article of an upgrade from 10 to 11, which I tried to kind of follow

that definitely didn’t work, /usr/pgsql/bin doesn’t even exist on my box.

If anyone has definite steps, or even a link they’ve gotten to work I’d appreciate you passing it along.

Thanks!

Hi @mathurin ,

I just stumbled upon this older post - did you manage to complete the upgrade or are you still stuck with 9.2?