Update database collation version [beta, prod]

[mtracz]

During deploys we can see warning in the logs:

err: WARNING:  database "toby-prod" has a collation version mismatch
err: DETAIL:  The database was created using collation version 2.31, but the operating system provides version 2.36.
err: HINT:  Rebuild all objects in this database that use the default collation and run ALTER DATABASE "toby-prod" REFRESH COLLATION VERSION, or build PostgreSQL with the right library version.

Prod:

• https://github.com/blumilksoftware/toby/actions/runs/7499867411/job/20417446503#step:11:331

Beta:

• https://github.com/blumilksoftware/toby/actions/runs/7475309567/job/20343190026#step:13:506

This happen probably after upgrade PostgreSQL database to the newer version. (It's doing automatically, because we have set image: postgres:15 in docker compose).

---

Possible solution:

1. Backup
2. Run manually on database server

REINDEX DATABASE <database name>;

ALTER DATABASE <database name> REFRESH COLLATION VERSION;

https://www.postgresql.org/docs/current/sql-altercollation.html#SQL-ALTERCOLLATION-NOTES

---

Additional steps:

We should lock postgreSQL version to prevent "silent updates"

• https://github.com/blumilksoftware/toby/blob/main/docker-compose.yml#L44
• https://github.com/blumilksoftware/toby/blob/main/environment/prod/deployment/beta/docker-compose.beta.yml#L49
• https://github.com/blumilksoftware/toby/blob/main/environment/prod/deployment/prod/docker-compose.prod.yml#L53

Actually used version: 15.5-1.pgdg120+1 (for this moment)

Also we should consider to use pg_upgrade tool during switching major versions.
https://www.postgresql.org/docs/15/pgupgrade.html