On Thu, Nov 7, 2024 at 3:59 PM Murthy Nunna <mnunna@fnal.gov> wrote:
rsync backups are not just incremental backups. They are incremental merged backups. You always get full backup at the end of the backup.
My database is 18TB. The very first backup took 14 hours. We just keep overwriting this full backup with daily rsyncs. The daily rsyncs take about 15 to 30 minutes depending up on the activity since last backup.
That looks a whole lot like the results you get from async Streaming Replication.
Which is, of course, a DR solution, NOT a backup solution.