Conversation

Notices

1. Embed this notice
   Mick 🇨🇦 (mick@cosocial.ca)'s status on Friday, 14-Nov-2025 04:31:23 JST Mick 🇨🇦

   A question for the #MastoAdmin community:

   What's your PostgreSQL backup strategy?

   How much data would you expect to lose if your primary DB died suddenly?

   Seconds? Hours? Days?

   #Mastodon #PostgreSQL

   • Embed this notice
     GNU/CaduGPT :chick_santa: (cadusilva@bolha.one)'s status on Friday, 14-Nov-2025 04:31:22 JST GNU/CaduGPT :chick_santa:

     in reply to

     @mick running once every 12 hours. So if the worst happen, there's this window of a couple of hours worth of toots, interactions and profile changes that would be lost.

   • Embed this notice
     GNU/CaduGPT :chick_santa: (cadusilva@bolha.one)'s status on Friday, 14-Nov-2025 04:43:51 JST GNU/CaduGPT :chick_santa:

     in reply to

     @mick yes, long story short, there's a script that dumps the DB, pipes it to pigz for compression and then the resulting file is encrypted using GPG and sent to a S3 server in another continent.

   • Embed this notice
     Mick 🇨🇦 (mick@cosocial.ca)'s status on Friday, 14-Nov-2025 04:43:52 JST Mick 🇨🇦

     in reply to

     • GNU/CaduGPT :chick_santa:

     @cadusilva just pg_dump via cron?