# Upgrade from 10 to 11 postgres update from v.13 db restore issue

**URL:** <https://forum.mattermost.com/t/upgrade-from-10-to-11-postgres-update-from-v-13-db-restore-issue/25320>\
**Category:** Upgrade\
**Created:** [October 16, 2025, 9:56am UTC](https://forum.mattermost.com/t/upgrade-from-10-to-11-postgres-update-from-v-13-db-restore-issue/25320 "2025-10-16T09:56:26Z")\
**Posts on this page:** 1\
**Showing post:** 5

<div class="post-metadata">

**Author:** ![ollejacobsen](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mattermost.com/ollejacobsen/32/9224_2.png) [@ollejacobsen](https://forum.mattermost.com/u/ollejacobsen)\
**Post date:** [October 17, 2025, 8:31am UTC](https://forum.mattermost.com/t/upgrade-from-10-to-11-postgres-update-from-v-13-db-restore-issue/25320/5 "2025-10-17T08:31:35Z")

</div>

Here is my working solution

**Backup**

1. Shut down the stack `docker compose down`

2. Start only the postgres container `docker compose up -d postgres`

3. Create a backup  
`docker exec -it docker-postgres-1 pg_dump mattermost -U mmuser --no-privileges > ./backup/postgres13-update-backup.sql`

4. Stop the db container `docker stop docker-postgres-1`

**Restore**

1. Adjust .env file  
`POSTGRES_IMAGE_TAG=16-alpine`  
`POSTGRES_DATA_PATH=./volumes/db16/var/lib/postgresql/data`

2. Bring up the db container only `docker compose up -d postgres`

3. Remove existing db:s  
`docker exec -it docker-postgres-1 dropdb mattermost -U mmuser`  
`docker exec -it docker-postgres-1 createdb mattermost -U mmuser`

4. Import the data  
`docker exec -i docker-postgres-1 psql -U mmuser -d mattermost < ./backup/postgres13-backup-mattermost.sql`

**Update Mattermost**

1. Adjust .env file  
`MATTERMOST_IMAGE_TAG=11.0`
2. Bring up the stack (in my case)  
`docker compose -f docker-compose.yml -f docker-compose.without-nginx.yml up -d`

---

_[View the full topic](https://forum.mattermost.com/t/upgrade-from-10-to-11-postgres-update-from-v-13-db-restore-issue/25320)._