| From: | Ron Johnson <ronljohnsonjr(at)gmail(dot)com> |
|---|---|
| To: | pgsql-admin <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: Running rsync backups in pg15 |
| Date: | 2024-11-08 14:08:36 |
| Message-ID: | CANzqJaA02zeZTUB=uFPfxgJ+=NUUy1cQP3E0=3u0ssHdL6qkMA@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
On Thu, Nov 7, 2024 at 3:59 PM Murthy Nunna <mnunna(at)fnal(dot)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!
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Achilleas Mantzios - cloud | 2024-11-08 14:57:28 | Re: number of updated or deleted tuples needed to trigger a VACUUM in any one table |
| Previous Message | Laurenz Albe | 2024-11-08 10:23:04 | Re: Running rsync backups in pg15 |