[Adminsysters] { jean } . backup .

[¬ `]

hi,


we have a date -- january 30 { 08:00 PM CET }
 


~ ` ``ezn





_____ EOM
¬` vo ezn





On Wednesday, January 8th, 2025 at 11:18 PM, Gaba <gaba at riseup.net> wrote:

> 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
> 

> 

> 

> _______________________________________________
> Adminsysters mailing list
> Adminsysters at lists.genderchangers.org
> https://lists.genderchangers.org/mailman/listinfo/adminsysters
-------------- 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/20250116/5d0272f6/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/20250116/5d0272f6/attachment.sig>