Thanks. I tried a lot of combinations. Based on the output of \l
List of databases
Name | Owner | Encoding | Collate | Ctype | ICU Locale | Locale Provider | Access privileges
------------+----------+----------+-------------+-------------+------------+-----------------+-----------------------
bar | foo | UTF8 | de_DE.UTF-8 | de_DE.UTF-8 | | libc |
customers | sisis | UTF8 | de_DE.UTF-8 | de_DE.UTF-8 | | libc |
...
postgres=# ALTER COLLATION "de_DE.UTF8" REFRESH VERSION;
ERROR: collation "de_DE.UTF8" for encoding "UTF8" does not exist
yours (Dominique) seems to work:
postgres=# ALTER COLLATION "de_DE.utf8" REFRESH VERSION;
NOTICE: version has not changed
ALTER COLLATION
If I understand the other reply from Laurenz Albe right, the correct procedure would be:
pgsql -Usisis sisis
sisis=# REINDEX (VERBOSE) DATABASE sisis;
sisis=# ALTER COLLATION "de_DE.utf8" REFRESH VERSION;
ALTER COLLATION
Correct?
Thanks for your hint, Jeremy. But this does not work either:
postgres=# SELECT collname, collversion FROM pg_collation where collname = 'de_DE.utf8';
collname | collversion
------------+-------------
de_DE.utf8 | 2.38
(1 row)
postgres=# ALTER COLLATION de_DE.utf8 REFRESH VERSION;
ERROR: schema "de_de" does not exist
What do I wrong?
Missing quotes. ALTER COLLATION "de_DE.utf8" REFRESH VERSION;
