openSUSE admin

tickets #170143

Updated by crameleon 4 months ago

``` 
 crameleon@mirrordb2:/home/crameleon> sudo -u postgres psql 
 [sudo] password for crameleon: 
 WARNING:    database "postgres" has a collation version mismatch 
 DETAIL:    The database was created using collation version 2.31, but the operating system provides version 2.38. 
 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. 
 psql (15.8) 
 Type "help" for help. 

 postgres=# 
 ``` 

 I already encountered this on the `template1` database the other day, there I solved it using: 

 ``` 
 REINDEX DATABASE template1; 
 ALTER DATABASE template1 REFRESH COLLATION VERSION; 
 ``` 

 I could not quite find any official documentation about whether that's the right procedure (regarding the hint "Rebuild all objects in this database that use the default collation") and am hence a bit reluctant to run it on the `postgres` database.

Back