Post 9xEErRcfw6AM3d9w7U by notcmhobbs@mastodon.sdf.org
 (DIR) More posts by notcmhobbs@mastodon.sdf.org
 (DIR) Post #9xEEBgrMtYa39T7c4u by alex@gleasonator.com
       2020-07-19T01:31:23.529099Z
       
       1 likes, 1 repeats
       
       Which is faster?ssh gleasonator pg_dump pleroma > pleroma.sqlvsssh gleasonator "pg_dump pleroma > pleroma.sql"rsync -av gleasonator:pleroma.sql .
       
 (DIR) Post #9xEErRcfw6AM3d9w7U by notcmhobbs@mastodon.sdf.org
       2020-07-19T01:37:29Z
       
       2 likes, 0 repeats
       
       @alex the second seems slightly more fault tolerant to me.  you'll be less burdened by a bad connection
       
 (DIR) Post #9xEEyAL2b6pmTh7F1k by alex@gleasonator.com
       2020-07-19T01:40:09.717974Z
       
       0 likes, 0 repeats
       
       @notcmhobbs It also uses less bandwidth since it compresses the file on the server before downloading, which is important because I had to actually switch ISPs to support doing hourly backups 😆
       
 (DIR) Post #9xEFETNpYYmgB7CFEm by Moon@shitposter.club
       2020-07-19T01:43:04.306668Z
       
       1 likes, 0 repeats
       
       @alex you want a z flag on that rsync otherwise you could pg_dump in custom format which is already compressed.
       
 (DIR) Post #9xEFMZ3IMcda4nRvvM by alex@gleasonator.com
       2020-07-19T01:44:34.297252Z
       
       0 likes, 0 repeats
       
       @Moon Wait a second... I thought -a was compress! Argh fuck I've been doing it wrong this whole time 😩
       
 (DIR) Post #9xEGZLchhfai97ffkm by feld@bikeshed.party
       2020-07-19T01:58:05.100083Z
       
       1 likes, 0 repeats
       
       @alex could compress inline ssh server "command | xz -c"Or something like that
       
 (DIR) Post #9xEHyqZPsdOxJur9JA by alex@gleasonator.com
       2020-07-19T02:13:53.314774Z
       
       0 likes, 0 repeats
       
       @feld Noice