Re: Running rsync backups in pg15 - Mailing list pgsql-admin

From Ron Johnson
Subject Re: Running rsync backups in pg15
Date
Msg-id CANzqJaA02zeZTUB=uFPfxgJ+=NUUy1cQP3E0=3u0ssHdL6qkMA@mail.gmail.com
Whole thread Raw
In response to RE: Running rsync backups in pg15  (Murthy Nunna <mnunna@fnal.gov>)
Responses RE: Running rsync backups in pg15
List pgsql-admin
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.

--
Death to <Redacted>, and butter sauce.
Don't boil me, I'm still alive.
<Redacted> lobster!

pgsql-admin by date:

Previous
From: Laurenz Albe
Date:
Subject: Re: Running rsync backups in pg15
Next
From: Achilleas Mantzios - cloud
Date:
Subject: Re: number of updated or deleted tuples needed to trigger a VACUUM in any one table