[Adminsysters] { jean } . backup .

[Gaba]

On 1/8/25 19:12, ¬ ` 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
>

Thanks! I will vote on the poll and we can look at the postgresql issues.

>
>
>
> -----------------------------------------------------.+++++++++==
>
> 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
>
>
>
>
> _______________________________________________
> Adminsysters mailing list
> Adminsysters at lists.genderchangers.org
> https://lists.genderchangers.org/mailman/listinfo/adminsysters