tianon / docker-postgres-upgrade

a PoC for using "pg_upgrade" inside Docker -- learn from it, adapt it for your needs; don't expect it to work as-is!
https://hub.docker.com/r/tianon/postgres-upgrade/
MIT License
1.09k stars 116 forks source link

Collation warning #90

Closed bartoszgralek closed 8 months ago

bartoszgralek commented 8 months ago

Hi!

I've just recently upgraded from 10 to 15, and mostly everything worked fine. I had to add also host all all all md5 to my pg_hba.config and then the container started. Now I am trying to get rid of this warning message that appears every time that something is being retrieved from database:

WARNING:  database "my_database" has no actual collation version, but a version was recorded

I've tried the things that people on the internet suggested like:

  1. REINDEX SYSTEM my_database
  2. REINDEX DATABASE my_database
  3. ALTER DATABASE my_database REFRESH COLLATION VERSION

but none of them seems to work. The guy here seems to have the same problem

Send help