[Adminsysters] { jean } . backup .

[Gaba]

ezn, oooo:

i fixed the warning on the mastodon database by reindexing it

REINDEX DATABASE mastodon_production;
ALTER DATABASE mastodon_production REFRESH COLLATION VERSION;



On 1/30/25 14:12, ¬ ` wrote:
> 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
>>
>
> _______________________________________________
> Adminsysters mailing list
> Adminsysters at lists.genderchangers.org
> https://lists.genderchangers.org/mailman/listinfo/adminsysters