KomuSolutions/igot99issues
3
0
Issues 14 Projects 1 Wiki

Upgrade to Postgres 16 #40

New Issue
Closed
opened 2024-06-09 20:27:15 +02:00 by lukas · 7 comments
lukas commented 2024-06-09 20:27:15 +02:00
Owner
Copy Link

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
libre.moe
 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
lukas commented 2024-06-09 20:33:14 +02:00
Author
Owner
Copy Link

https://github.com/pgautoupgrade/docker-pgautoupgrade

https://github.com/pgautoupgrade/docker-pgautoupgrade
lukas added the
Priority
Low
 label 2024-06-09 20:41:28 +02:00
lukas commented 2024-06-09 21:42:32 +02:00
Author
Owner
Copy Link

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.
lukas commented 2024-06-09 21:45:33 +02:00
Author
Owner
Copy Link

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.
lukas commented 2024-06-15 12:02:49 +02:00
Author
Owner
Copy Link

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
lukas commented 2024-06-15 13:58:06 +02:00
Author
Owner
Copy Link

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
lukas commented 2024-06-16 14:36:48 +02:00
Author
Owner
Copy Link

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
pgupdate.log
16 KiB
lukas commented 2024-06-16 14:55:43 +02:00
Author
Owner
Copy Link

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
lukas removed this from the Issue Board project 2024-12-17 12:27:58 +01:00
Sign in to join this conversation.
No Branch/Tag Specified
Branches Tags
Labels
Clear labels   
Breaking

Breaking change that won't be backward compatible

  
Domain
komu.boo

  
Domain
langrock.info

  
Domain
libre.moe

  
Involves
Documentation
Issue invovles changing the documentation

  
Involves
Security
This is security issue

  
Involves
Testing
Issue or pull request related to testing

  
Kind
Bug
Something is not working

  
Kind
Enhancement
Improve existing functionality

  
Priority
Critical
The priority is critical

  
Priority
High
The priority is high

  
Priority
Low
The priority is low

  
Priority
Medium
The priority is medium

  
Service
Drone

  
Service
Element

  
Service
Gitea

  
Service
Matrix

  
Service
Nextcloud

  
Service
Szuru

  
Status
Abandoned
Somebody has started to work on this but abandoned work

  
Status
Blocked
Something is blocking this issue or pull request

  
Status
Duplicate
This issue or pull request already exists

  
Status
Invalid
Invalid issue

  
Status
Need More Info
Feedback is required to reproduce issue or to continue work

  
Status
Planned
Issue has been confirmed and is planned to be resolved

  
Status
Won't Fix
This issue won't be fixed

No Label
Breaking
Domain
komu.boo
Domain
langrock.info
Domain
libre.moe
Involves
Documentation
Involves
Security
Involves
Testing
Kind
Bug
Kind
Enhancement
Priority
Critical
Priority
High
Priority
Low
Priority
Medium
Service
Drone
Service
Element
Service
Gitea
Service
Matrix
Service
Nextcloud
Service
Szuru
Status
Abandoned
Status
Blocked
Status
Duplicate
Status
Invalid
Status
Need More Info
Status
Planned
Status
Won't Fix
Milestone
Clear milestone
No items
No Milestone
Projects
Clear projects
No project
Assignees
Clear assignees
No Assignees
lukas
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.
Delete Branch "%!s()"

Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?