Emelia/Emi on Nostr: Finally got around to setting up postgres "backups." (To a different disk on the same ...

Finally got around to setting up postgres "backups." (To a different disk on the same host. rsync to my NAS is TODO) Why does postgres streaming replication not support first-class bandwidth limits... I really don't want to simply throttle the fuck out of it directly with iptables... (I really wish docsis had better upload speeds...)

(Also, it's nice that pg_combinebackup exists, which allows for maintaining a rolling "base backup" for a retention policy, which is useful on small but high-turnover DBs, while still allowing for "every backup send is incremental")