Re:Postgres Incremental Backup
by devnonymous on Thursday January 11, 2024 @11:56PM
(#38963949)
I'm willing to bet that beyond a certain threshold there's no use for an incremental backup. You either would use (delayed) replication[1] to have an 'incremental' copy or would take full backups. I don't think any large database users rushing to use incremental backups when they have full redundancy.
Re:Postgres Incremental Backup
by rhaas on Friday January 12, 2024 @08:38AM
(#38967760)
I agree that for many use cases, standbys and in particular time-delayed standbys are a better option than backups. That said, having off-line backups in tamper-proof storage is a good call, too.
[1] for example https://about.gitlab.com/blog/2019/02/13/delayed-replication...