Page MenuHomeSoftware Heritage

Fix default collation configuration on staging databases
Closed, MigratedEdits Locked

Description

Following a discussion on irc, we installed the staging db without specifying a collation.
This resulted in configuring en_US.UTF-8 on staging db (or even on the provenance server).
This creates sorting discrepancies down the line [2].

This should be fixed.
The M.O. is to create a db dump, scratch the db, create a new one (with the proper collation), finally restore the dump on new db [3]

[1] https://www.postgresql.org/docs/12/collation.html

[2] P1236

[3] Top of my head following the discussion, this needs proper documentation source link

Event Timeline

ardumont renamed this task from Fix default collation on staging database to Fix default collation on staging databases.Dec 6 2021, 5:58 PM
ardumont renamed this task from Fix default collation on staging databases to Fix default collation configuration on staging databases.
ardumont triaged this task as Normal priority.
ardumont created this task.
ardumont updated the task description. (Show Details)