<div style="font-family: Menlo, Consolas, Courier New, Monospace; font-size: 14px;">hi,</div><div style="font-family: Menlo, Consolas, Courier New, Monospace; font-size: 14px;"><br></div><div style="font-family: Menlo, Consolas, Courier New, Monospace; font-size: 14px;">today ooooo, ai and i met to install borg on jean and start backing it up to leverburns {they are already on the same tinc network `internes`}.</div><div style="font-family: Menlo, Consolas, Courier New, Monospace; font-size: 14px;"><br></div><div style="font-family: Menlo, Consolas, Courier New, Monospace; font-size: 14px;"><span style="font-family:Menlo, Consolas, Courier New, Monospace">:.`` documentation <br></span></div><div style="font-family: Menlo, Consolas, Courier New, Monospace; font-size: 14px;"><span style="font-family:Menlo, Consolas, Courier New, Monospace"> <span><a target="_blank" rel="noreferrer nofollow noopener" href="https://eth.leverburns.blue/p/borg">https://eth.leverburns.blue/p/borg</a><br></span></span></div><div style="font-family: Menlo, Consolas, Courier New, Monospace; font-size: 14px;"><span style="font-family:Menlo, Consolas, Courier New, Monospace"><span><br></span></span></div><div style="font-family: Menlo, Consolas, Courier New, Monospace; font-size: 14px;"><span style="font-family:Menlo, Consolas, Courier New, Monospace">:.`` poll for next session {wrap up jean backup config + bring back adele backup process} <br></span></div><div style="font-family: Menlo, Consolas, Courier New, Monospace; font-size: 14px;"><span style="font-family:Menlo, Consolas, Courier New, Monospace"> <span><a target="_blank" rel="noreferrer nofollow noopener" href="https://transitional.anarchaserver.org/date/adminstuds.php?poll=WJWvfK736KvEHBWdvFWRQw6o" style="">https://transitional.anarchaserver.org/date/adminstuds.php?poll=WJWvfK736KvEHBWdvFWRQw6o</a><br></span></span></div><div style="font-family: Menlo, Consolas, Courier New, Monospace; font-size: 14px;"><span style="font-family:Menlo, Consolas, Courier New, Monospace"><span><br></span></span></div><div style="font-family: Menlo, Consolas, Courier New, Monospace; font-size: 14px;"><span style="font-family:Menlo, Consolas, Courier New, Monospace"><span><br></span></span></div><div style="font-family: Menlo, Consolas, Courier New, Monospace; font-size: 14px;"><br></div><div style="font-family: Menlo, Consolas, Courier New, Monospace; font-size: 14px;">-----------------------------------------------------.+++++++++==</div><div style="font-family: Menlo, Consolas, Courier New, Monospace; font-size: 14px;"><br></div><div style="font-family: Menlo, Consolas, Courier New, Monospace; font-size: 14px;">we installed borg and gave jean ssh access to leverburns</div><div style="font-family: Menlo, Consolas, Courier New, Monospace; font-size: 14px;">we copied and modified a backup script ~ run.sh ~ from adele</div><div style="font-family: Menlo, Consolas, Courier New, Monospace; font-size: 14px;"><span spellcheck="true"><span><a href="https://git.systerserver.net/systerserver/notes/-/issues/33" rel="noreferrer noopener">https://git.systerserver.net/systerserver/notes/-/issues/33</a></span></span><br></div><div style="font-family: Menlo, Consolas, Courier New, Monospace; font-size: 14px;"><br></div><div style="font-family: Menlo, Consolas, Courier New, Monospace; font-size: 14px;">at the moment we are backing up</div><div style="font-family: Menlo, Consolas, Courier New, Monospace; font-size: 14px;"> <span>/opt/ /etc/ /var/ /home/mastodon/ /usr/local/etc/tinc/ /var/lib/redis/dump.rdb </span><br></div><div style="font-family: Menlo, Consolas, Courier New, Monospace; font-size: 14px;"><br></div><div style="font-family: Menlo, Consolas, Courier New, Monospace; font-size: 14px;">the latter is related to mastodon; we also wanted to incorporate postgres database dump into backups but it got complicated:</div><div style="font-family: Menlo, Consolas, Courier New, Monospace; font-size: 14px;">first, there were issues with accessing pg_dump operation for mastodon database, so we updated <span>/etc/postgresql/17/main/pg_hba.conf </span>with mastodon database credentials. this gave us access but then we ran into:</div><div style="font-family: Menlo, Consolas, Courier New, Monospace; font-size: 14px;"><br></div><div style="font-family: Menlo, Consolas, Courier New, Monospace; font-size: 14px;"><div spellcheck="true" align="center" style="text-align: center;"><div><span style="font-family:Menlo, Consolas, Courier New, monospace;font-size:14px;line-height:normal;font-weight:400">WARNING: database "mastodon_production" has a collation version mismatch</span></div><div><span style="font-family:Menlo, Consolas, Courier New, monospace;font-size:14px;line-height:normal;font-weight:400">DETAIL: The database was created using collation version 2.31, but the operating system provides version 2.36.</span></div><div><span style="font-family:Menlo, Consolas, Courier New, monospace;font-size:14px;line-height:normal;font-weight:400">HINT:
Rebuild all objects in this database that use the default collation and
run ALTER DATABASE mastodon_production REFRESH COLLATION VERSION, </span></div><div><span style="font-family:Menlo, Consolas, Courier New, monospace;font-size:14px;line-height:normal;font-weight:400">or build PostgreSQL with the right library version.</span></div></div><div spellcheck="true"></div><div spellcheck="true"></div><div spellcheck="true"><div><br></div></div><div spellcheck="true"></div> ./ would be great to look into this together with you, gaba</div><div style="font-family: Menlo, Consolas, Courier New, Monospace; font-size: 14px;"><br></div><div style="font-family: Menlo, Consolas, Courier New, Monospace; font-size: 14px;"><br></div><div style="font-family: Menlo, Consolas, Courier New, Monospace; font-size: 14px;">we started running `borg create` command via run.sh script in the afternoon and it is still not finished.</div><div style="font-family: Menlo, Consolas, Courier New, Monospace; font-size: 14px;">first-time long run is expected but <span>/home/mastodon/</span>live/public/ directory is quite heavy</div><div style="font-family: Menlo, Consolas, Courier New, Monospace; font-size: 14px;"><span><br></span></div><div style="font-family: Menlo, Consolas, Courier New, Monospace; font-size: 14px;"><span>181G /home/mastodon/live/public/system</span><br></div><div style="font-family: Menlo, Consolas, Courier New, Monospace; font-size: 14px;"><br></div><div style="font-family: Menlo, Consolas, Courier New, Monospace; font-size: 14px;"> ./ i think it's worth addressing how {long} we retain media from federated instances on our server</div><div style="font-family: Menlo, Consolas, Courier New, Monospace; font-size: 14px;"><br></div><div style="font-family: Menlo, Consolas, Courier New, Monospace; font-size: 14px;"><br></div><div style="font-family: Menlo, Consolas, Courier New, Monospace; font-size: 14px;">atm timer {<span spellcheck="true"><code><span>automatic-backup.timer file</span></code></span>} is set to execute the backup script at 4 am every night, just like on adele</div><div style="font-family: Menlo, Consolas, Courier New, Monospace; font-size: 14px;"><br></div><div style="font-family: Menlo, Consolas, Courier New, Monospace; font-size: 14px;"> ./ maybe it's best to not have leverburns receiving backups from 2 servers at the same time?</div><div style="font-family: Menlo, Consolas, Courier New, Monospace; font-size: 14px;"><br></div><div style="font-family: Menlo, Consolas, Courier New, Monospace; font-size: 14px;"><br></div><div style="font-family: Menlo, Consolas, Courier New, Monospace; font-size: 14px;">and similarly to adele configuration sysadmins would receive mail report for jean nightly backups<br></div><div style="font-family: Menlo, Consolas, Courier New, Monospace; font-size: 14px;"> <br></div><div style="font-family: Menlo, Consolas, Courier New, Monospace; font-size: 14px;">-----------------------------------------------------.+++++++++==</div><div style="font-family: Menlo, Consolas, Courier New, Monospace; font-size: 14px;"><br></div><div style="font-family: Menlo, Consolas, Courier New, Monospace; font-size: 14px;">once we are done with jean backup todo's, let's restore adele backup situation</div><div style="font-family: Menlo, Consolas, Courier New, Monospace; font-size: 14px;"> _-/ upgrade debian</div><div style="font-family: Menlo, Consolas, Courier New, Monospace; font-size: 14px;"> _-/ install tinc</div><div style="font-family: Menlo, Consolas, Courier New, Monospace; font-size: 14px;"> _-/ install dropbear if it's still possible</div><div style="font-family: Menlo, Consolas, Courier New, Monospace; font-size: 14px;"> <br></div><div class="protonmail_signature_block" style="font-family: Menlo, Consolas, Courier New, Monospace; font-size: 14px;"><div class="protonmail_signature_block-user"><div>. . .. .. . .. . . . . .. .. . . . .. . . .. . . . . . . . ...</div><div><br></div><div><br></div><div>~``ezn<br></div><div><span class="font" style="font-family:menlo, consolas, 'courier new', monospace, sans-serif;"></span><br></div><div><span class="colour" style="color: rgb(42, 71, 246);"></span><span class="font" style="font-family:menlo, consolas, 'courier new', monospace, sans-serif;"></span><br></div><div class="protonmail_signature_block"><div class="protonmail_signature_block-user"><div><span><span class="font" style="font-family:menlo, consolas, 'courier new', monospace, sans-serif;"><span class="size" style="font-size:12px;">_____ EOM</span></span></span><br></div><div><span><span class="font" style="font-family:menlo, consolas, 'courier new', monospace, sans-serif;"><span class="size" style="font-size:12px;">¬` </span></span></span><a title="http://ezn.leverburns.blue/" href="http://ezn.leverburns.blue/"><span><span class="font" style="font-family:menlo, consolas, 'courier new', monospace, sans-serif;"><span class="size" style="font-size:12px;">vo ezn</span></span></span></a><br></div><div><br></div></div></div><div><div><br></div></div><div><br></div>
</div>
<div class="protonmail_signature_block-proton protonmail_signature_block-empty">
</div>
</div>