> ## Content Index
> Fetch the complete content index at: https://note.xdq.me/llms.txt
> Use this file to discover other available public pages before exploring further.

# Postgresql database "DatabaseName" has a collation version mismatch
- URL: https://note.xdq.me/postgresql-database-has-a-collation-version-mismatch/
- Published: 2025-12-06T05:36:08.000Z
- Updated: 2026-08-19T01:08:37.000Z
- Author: xud6
- Tags: linux, postgresql, #Import 2026-10-03 02:45

```
su - postgres
psql

\c DatabaseName

ALTER DATABASE DatabaseName REFRESH COLLATION VERSION;

REINDEX DATABASE DatabaseName;

```