# Problems Upgrading Postgres database 9.2 to 11

**URL:** <https://forum.mattermost.com/t/problems-upgrading-postgres-database-9-2-to-11/11697>\
**Category:** Troubleshooting\
**Created:** [May 19, 2021, 1:34am UTC](https://forum.mattermost.com/t/problems-upgrading-postgres-database-9-2-to-11/11697 "2021-05-19T01:34:12Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![mathurin](https://avatars.discourse-cdn.com/v4/letter/m/bcef8e/32.png) [@mathurin](https://forum.mattermost.com/u/mathurin)\
**Post date:** [May 19, 2021, 1:34am UTC](https://forum.mattermost.com/t/problems-upgrading-postgres-database-9-2-to-11/11697/1 "2021-05-19T01:34:12Z")

</div>

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/](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

> **[Mattermost 5.x with CentOS 7.x and PostgreSQL 11.x](https://frankbaier.medium.com/mattermost-5-x-with-centos-7-x-and-postgresql-11-x-500264feae3d)**
>
> My Mattermost Test Server is running with CentOS 7.5.1804 at Kernel 4.19.1 with Mattermost 5.4.0 and PostgreSQL 10.6. After the following…

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!

---

<div class="post-metadata">

**Author:** ![agriesser](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mattermost.com/agriesser/32/5644_2.png) [@agriesser](https://forum.mattermost.com/u/agriesser)\
**Post date:** [April 17, 2023, 4:40am UTC](https://forum.mattermost.com/t/problems-upgrading-postgres-database-9-2-to-11/11697/2 "2023-04-17T04:40:00Z")

</div>

Hi @mathurin ,

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