| 31 Aug 2024 |
 hacker1024 | * I am getting a lot of these messages from hydra-server and hydra-send-stats after upgrading nixos-unstable. Is there a manual step that needs to be done? I did not change my system stateVersion.
WARNING: database "hydra" has a collation version mismatch
DETAIL: The database was created using collation version 2.38, but the operating system provides version 2.39.
HINT: Rebuild all objects in this database that use the default collation and run ALTER DATABASE hydra REFRESH COLLATION VERSION, or build PostgreSQL with the right library version.
| 11:47:36 |
| hacker1024 | * I am getting a lot of these messages from hydra-server and hydra-send-stats after upgrading nixos-unstable. Is there a manual step that needs to be done? I did not change my system stateVersion.
WARNING: database "hydra" has a collation version mismatch
DETAIL: The database was created using collation version 2.38, but the operating system provides version 2.39.
HINT: Rebuild all objects in this database that use the default collation and run ALTER DATABASE hydra REFRESH COLLATION VERSION, or build PostgreSQL with the right library version.
| 11:47:42 |
 K900 | It literally tells you what to do | 11:49:50 |
| hacker1024 | I am not familiar with SQL or SQL servers in general. Am I supposed to use some tool to open a PostgeSQL console? | 11:51:19 |
| hacker1024 | And I'm not sure what are keywords or placeholders in the given command | 11:51:53 |
| hacker1024 | Or if Hydra needs to be stopped during this process | 11:52:21 |
 @rick:matrix.ciphernetics.nl | Hmm, maybe PostgreSQL updated? Normally this shouldn't happen, and nothing in the hydra schema changed | 13:50:17 |
| 2 Sep 2024 |
 @janne.hess:helsinki-systems.de | It happens when the glibc version of postgres changes | 06:48:10 |
|  stigo joined the room. | 10:43:54 |
| 3 Sep 2024 |
 Sandro 🐧 | sudo -u postgres psql and run the command | 12:14:17 |
| @rick:matrix.ciphernetics.nl | Maybe something for the wiki | 17:48:25 |
|  noisersup joined the room. | 17:58:00 |
