Upgrade to Postgres 16 #40

Closed
opened 2024-06-09 20:27:15 +02:00 by lukas · 7 comments
Owner

We are currently using version 13, first released in September 2020 and supported until November 2025. While this version is still supported for at least a year, Postgres is currently gearing up to its 17 release, so it's probably a good time to upgrade to the current latest version. The 16 release came out in September 2023 and will be supported until November 2028.

The reason this upgrade wasn't made already is that, like with many databases, major releases carry storage schema changes and are not compatible with data from previous versions, which prompts for a migration/upgrade. As all services on libre.moe use a singular database, this wasn't done before as it requires a decent amount of downtime and time for testing.

We are currently using version 13, first released in September 2020 and supported until November 2025. While this version is still supported for at least a year, Postgres is currently gearing up to its 17 release, so it's probably a good time to upgrade to the current latest version. The 16 release came out in September 2023 and will be supported until November 2028. The reason this upgrade wasn't made already is that, like with many databases, major releases carry storage schema changes and are not compatible with data from previous versions, which prompts for a migration/upgrade. As all services on libre.moe use a singular database, this wasn't done before as it requires a decent amount of downtime and time for testing.
lukas added the
Involves
Testing
Domain
LibreMoe
labels 2024-06-09 20:27:15 +02:00
lukas self-assigned this 2024-06-09 20:27:15 +02:00
lukas added this to the Issue Board project 2024-06-09 20:27:15 +02:00
Author
Owner
https://github.com/pgautoupgrade/docker-pgautoupgrade
lukas added the
Priority
Low
label 2024-06-09 20:41:28 +02:00
Author
Owner

During this migration, I will also copy over the db from arael to armisael so that each server can have it's own db. There have been times in the past, where an outage/reboot of arael caused services on armisael to be unavailable due to depending on the db on arael.

During this migration, I will also copy over the db from arael to armisael so that each server can have it's own db. There have been times in the past, where an outage/reboot of arael caused services on armisael to be unavailable due to depending on the db on arael.
Author
Owner

In the future, this could also be used to synchronize the two DBs, so that one db can take over responsibility while the other one is restarting and vice-versa.

In the future, this could also be used to synchronize the two DBs, so that one db can take over responsibility while the other one is restarting and vice-versa.
Author
Owner

Verify support for Postgres 16 with all services using it as db:

  • Keycloak (starting with v25)
  • Nextcloud (starting with v29)
  • Gitea (>= 12 supported)
  • Drone (>= 9.6 supported)
  • Vaultwarden (seems like the diesel-rs lib doesn't care)
  • Szuru (inofficial, reported to be working good by community)
Verify support for Postgres 16 with all services using it as db: - [x] Keycloak (starting with v25) - [x] Nextcloud (starting with v29) - [x] Gitea (>= 12 supported) - [x] Drone (>= 9.6 supported) - [x] Vaultwarden (seems like the diesel-rs lib doesn't care) - [x] Szuru (inofficial, [reported](https://github.com/rr-/szurubooru/issues/612) to be working good by community)
lukas started working 2024-06-15 12:08:57 +02:00
lukas stopped working 2024-06-15 12:44:20 +02:00
35 minutes 23 seconds
lukas added the due date 2024-06-16 2024-06-15 13:57:23 +02:00
Author
Owner

Upgrade will commence tomorrow at 14:00 CEST
https://status.libre.moe/maintenance/384717

Upgrade will commence tomorrow at 14:00 CEST https://status.libre.moe/maintenance/384717
lukas added spent time 2024-06-16 14:24:47 +02:00
24 minutes
lukas started working 2024-06-16 14:24:50 +02:00
Author
Owner

Arael is now fully operational again, moving on to adding the db to Armisael

Arael is now fully operational again, moving on to adding the db to Armisael
Author
Owner

Database has been moved over, db's have been balanced (arael: -nextcloud, armisael: -*\nextcloud), backup routines have been adjusted.

Database has been moved over, db's have been balanced (arael: -nextcloud, armisael: -*\nextcloud), backup routines have been adjusted.
lukas closed this issue 2024-06-16 14:55:43 +02:00
lukas stopped working 2024-06-16 14:55:43 +02:00
30 minutes 53 seconds
Sign in to join this conversation.
No Milestone
No project
No Assignees
1 Participants
Notifications
Total Time Spent: 1 hour 30 minutes
lukas
1 hour 30 minutes
Due Date
The due date is invalid or out of range. Please use the format 'yyyy-mm-dd'.

2024-06-16

Dependencies

No dependencies set.

Reference: KomuSolutions/igot99issues#40
No description provided.