# Can't recreate pg from snapshot: "The database was created using collation version 2.31, but the operating system provides version 2.36"

**URL:** <https://community.fly.io/t/cant-recreate-pg-from-snapshot-the-database-was-created-using-collation-version-2-31-but-the-operating-system-provides-version-2-36/19480>\
**Category:** Questions / Help\
**Tags:** postgres, login-only\
**Created:** [April 25, 2024, 9:12pm UTC](https://community.fly.io/t/cant-recreate-pg-from-snapshot-the-database-was-created-using-collation-version-2-31-but-the-operating-system-provides-version-2-36/19480 "2024-04-25T21:12:24Z")\
**Posts on this page:** 1\
**Showing post:** 2

<div class="post-metadata">

**Author:** ![shaun](https://avatars.discourse-cdn.com/v4/letter/s/f07891/32.png) [@shaun](https://community.fly.io/u/shaun)\
**Post date:** [April 26, 2024, 1:50am UTC](https://community.fly.io/t/cant-recreate-pg-from-snapshot-the-database-was-created-using-collation-version-2-31-but-the-operating-system-provides-version-2-36/19480/2 "2024-04-26T01:50:48Z")

</div>

Did you try this by chance?

> [@postgres-flex: database "postgres" has a collation version mismatch](https://community.fly.io/t/postgres-flex-database-postgres-has-a-collation-version-mismatch/14391):
>
> Just recently a new release of postgres-flex was published. Because the Debian version of the base image has been updated, you may see a message like this: database [DATABASE NAME] has a collation version mismatch. There are a few things you need to do here, but in many cases you should be able to resolve this in the following steps: Update the app’s image to the latest available version: fly image update ... List all available databases: postgres=# \l If you’re not sure about the backsl…

---

_[View the full topic](https://community.fly.io/t/cant-recreate-pg-from-snapshot-the-database-was-created-using-collation-version-2-31-but-the-operating-system-provides-version-2-36/19480)._