starting #pixie.town Matrix maintenance in 15 minutes
filesystem-level backup on 62% (20 min est), still cleaning up unreferenced state entries and can then start the postgres dump
running pg REINDEX now, dump after that
after this other postgres business is finished, I can ZFS snapshot the filesystem-level backup, and rsync over just the last changes too
this migration involves lots of waiting and I keep tabbing to Matrix (my normal procrastination habit) and realizing it's offline
filesystem 92%, this reindex might take ages though
reindex done, fs backup done, about halfway through postgres dump
time to drop the old database 😬 😬 😬
DBA wisdom Show more
@f0x Better check all your backups one more time before you do
@ghost_bird yep i did
@ghost_bird nightly in borg, filesystem on different disk (snapshotted twice at different points), db dump nightly, db dump now (snapshotted too)
@f0x Sounds like you have the appropriate amount of 😬😬😬 then. Go to it and good luck
Small server part of the pixie.town infrastructure. Registration is closed.
DBA wisdom
@ghost_bird nightly in borg, filesystem on different disk (snapshotted twice at different points), db dump nightly, db dump now (snapshotted too)