Conversation

Notices

1. Embed this notice
   Martijn Braam (martijnbraam@fosstodon.org)'s status on Friday, 28-Feb-2025 22:25:27 JST Martijn Braam

   The fun thing about matrix is migrating that 100GB postgres database to the next major version so synapse can connect again...

   • Johnny Peligro likes this.
   • Embed this notice
     SuperDicq (superdicq@minidisc.tokyo)'s status on Friday, 28-Feb-2025 22:25:27 JST SuperDicq

     in reply to

     @martijnbraam@fosstodon.org Do you know about the pg_upgrade --link option?

   • Embed this notice
     SuperDicq (superdicq@minidisc.tokyo)'s status on Friday, 28-Feb-2025 22:42:10 JST SuperDicq

     in reply to

     @martijnbraam@fosstodon.org Alright if your pg_upgrade job is taking too long, cancel it and run it with --link. Trust me.

   • Embed this notice
     Martijn Braam (martijnbraam@fosstodon.org)'s status on Friday, 28-Feb-2025 22:42:11 JST Martijn Braam

     in reply to

     • SuperDicq

     @SuperDicq no I don't, I never manage pgsql :P

   • Embed this notice
     SuperDicq (superdicq@minidisc.tokyo)'s status on Friday, 28-Feb-2025 23:03:00 JST SuperDicq

     in reply to

     @martijnbraam@fosstodon.org Yes, you can use --link.
     
     All you gotta know is that --link doesn't copy your cluster, but it just turns the old into a new one. Which means you gotta take care of backups yourself.
     
     But you already have a proper backup strategy, right? 🤨

   • Embed this notice
     Martijn Braam (martijnbraam@fosstodon.org)'s status on Friday, 28-Feb-2025 23:03:01 JST Martijn Braam

     in reply to

     • SuperDicq

     @SuperDicq this is a pg_upgradecluster job, does that work the same way?

   • Embed this notice
     Martijn Braam (martijnbraam@fosstodon.org)'s status on Saturday, 01-Mar-2025 08:20:19 JST Martijn Braam

     in reply to

     • SuperDicq

     @SuperDicq well that worked out pretty great in the end :P

   • Embed this notice
     SuperDicq (superdicq@minidisc.tokyo)'s status on Saturday, 01-Mar-2025 08:20:19 JST SuperDicq

     in reply to

     @martijnbraam@fosstodon.org Cool, glad to have saved you multiple hours of your time with a single command argument.