[Adminsysters] { jean } . backup .

[¬ `]

hi,

reminder ~ we meet today at 08:00 PM CET ~

~`` `ezn






_____ EOM
¬` vo ezn





On Wednesday, January 8th, 2025 at 11:12 PM, ¬ ` <vo.ezn at leverburns.blue> wrote:

> hi,
> 

> 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`}.
> 

> :.`` documentation
> 

>      https://eth.leverburns.blue/p/borg
> 

> 

> :.`` poll for next session {wrap up jean backup config + bring back adele backup process}
> 

>      https://transitional.anarchaserver.org/date/adminstuds.php?poll=WJWvfK736KvEHBWdvFWRQw6o
> 

> 

> 

> 

> 

> -----------------------------------------------------.+++++++++==
> 

> we installed borg and gave jean ssh access to leverburns
> we copied and modified a backup script ~ run.sh ~ from adele
> https://git.systerserver.net/systerserver/notes/-/issues/33
> 

> at the moment we are backing up
>         /opt/ /etc/ /var/ /home/mastodon/ /usr/local/etc/tinc/ /var/lib/redis/dump.rdb
> 

> the latter is related to mastodon; we also wanted to incorporate postgres database dump into backups but it got complicated:
> first, there were issues with accessing pg_dump operation for mastodon database, so we updated /etc/postgresql/17/main/pg_hba.conf with mastodon database credentials. this gave us access but then we ran into:
> 

> WARNING:  database "mastodon_production" has a collation version mismatch
> DETAIL:  The database was created using collation version 2.31, but the operating system provides version 2.36.
> HINT:  Rebuild all objects in this database that use the default collation and run ALTER DATABASE mastodon_production REFRESH COLLATION VERSION, 
> or build PostgreSQL with the right library version.
> 

> 

> 

>         ./ would be great to look into this together with you, gaba
> 

> 

> we started running `borg create` command via run.sh script in the afternoon and it is still not finished.
> first-time long run is expected but /home/mastodon/live/public/ directory is quite heavy
> 

> 

> 181G    /home/mastodon/live/public/system
> 

>        ./ i think it's worth addressing how {long} we retain media from federated instances on our server
> 

> 

> atm timer {`automatic-backup.timer file`} is set to execute the backup script at 4 am every night, just like on adele
> 

>         ./ maybe it's best to not have leverburns receiving backups from 2 servers at the same time?
> 

> 

> and similarly to adele configuration sysadmins would receive mail report for jean nightly backups
>             
> -----------------------------------------------------.+++++++++==
> 

> once we are done with jean backup todo's, let's restore adele backup situation
>        _-/ upgrade debian
>        _-/ install tinc
>        _-/ install dropbear if it's still possible
>       
> . . .. .. . .. . . . . ..  ..  . . . .. . .  .. . . . . . . . ...
> 

> 

> ~``ezn
> 

> 

> _____ EOM
> ¬` vo ezn
> 

> 

> 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.genderchangers.org/pipermail/adminsysters/attachments/20250130/9c550e11/attachment.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: publickey - vo.ezn at leverburns.blue - 0x7E9B40DC.asc
Type: application/pgp-keys
Size: 661 bytes
Desc: not available
URL: <http://lists.genderchangers.org/pipermail/adminsysters/attachments/20250130/9c550e11/attachment.key>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 343 bytes
Desc: OpenPGP digital signature
URL: <http://lists.genderchangers.org/pipermail/adminsysters/attachments/20250130/9c550e11/attachment.sig>