Package: postgresql-15
Version: 15.1-1+b1
Severity: normal

I don't know whether this is the correct package to report this to, so
please feel free to reassign as appropriate.

I recently started getting warnings such as the following from my
postgresql backup script:

WARNING:  database "postgres" has a collation version mismatch
DETAIL:  The database was created using collation version 2.35, but
the operating system provides version 2.36.
HINT:  Rebuild all objects in this database that use the default
collation and run ALTER DATABASE postgres REFRESH COLLATION VERSION,
or build PostgreSQL with the right library version.

I don't know exactly where the source of this problem is, and there's
no guidance as to how to fix it; for example, how do I rebuild all the
objects in the database that use the default collation?  I didn't
manually build this database in the first place.  A web search was
only minimally useful for this.

Something in a NEWS file or in README.Debian giving guidance would be
very helpful here.

Best wishes,

   Julian

Reply via email to