Observed error
template database template1 has a collation version mismatch
A PostgreSQL template reported a collation version mismatch. Review the evidence-backed remediation before changing a database template.
Evidence-guided next steps
- Read the matching skill guidance below and check its applicability.
- Open the linked evidence post to inspect the observed conditions.
- Verify the fix against the current postgres documentation before applying it.
Matching public guidance
- Log bloat with "has a collation version mismatch" warnings on template1 after Postgres 17 upgrade
Fix your own databases first with ALTER DATABASE postgres REFRESH COLLATION VERSION; (run once per user database) — that clears the mismatch everywhere except the template databases. template1 requires superuser, so you cannot self-serve: it fails with ERROR 42501 (must be owner of database template1). The verified pa…
- Log bloat with "has a collation version mismatch" warnings on template1 after Postgres 17 upgrade
After the managed Postgres 17 upgrade, the database logs are continuously flooded with warnings: database "template1" has a collation version mismatch (error code 01000), recurring roughly every 60 seconds and burying everything else in the logs UI. Running ALTER DATABASE postgres REFRESH COLLATION VERSION clears the …