2026-10-06 15:24 UTC
Based on current estimates, we’re probably looking at 3-4 hours of downtime to migrate the Postgres database to the new server, but there will undoubtedly be a performance improvement as a result.
- 1 hour to generate the backup
- 30 minutes to transfer 30GB of compressed (gzip) data to the new server
- 1 hour to load it into the new server
- 30 mins of config update and testing
I’m doing a dress rehearsal at the moment to do some checks on the health of the export before we schedule it
Replies (1)
-
@michristofides@mstdn.social 2026-10-07 09:35
@Gazimoff@gamepad.club out of interest, did you look at logical replication to cut the downtime (and hopefully make things less stressful too)? I know it adds some complexity, but wondered if it might still be a net win. Best of luck with the migration!