public inbox for [email protected]
help / color / mirror / Atom feedFrom: Ron Johnson <[email protected]>
To: pgsql-admin <[email protected]>
Subject: Re: Running rsync backups in pg15
Date: Fri, 8 Nov 2024 09:08:36 -0500
Message-ID: <CANzqJaA02zeZTUB=uFPfxgJ+=NUUy1cQP3E0=3u0ssHdL6qkMA@mail.gmail.com> (raw)
In-Reply-To: <DM8PR09MB6677705AE81436745B4487F6B85C2@DM8PR09MB6677.namprd09.prod.outlook.com>
References: <CANzqJaCr-id_4YotukPeH=rHCELS58Z63FoEbkNFBSqzjGMueQ@mail.gmail.com>
<01000193082d1077-34d9461d-49e4-44ef-b83a-0201df4fc0ba-000000@email.amazonses.com>
<DM8PR09MB6677705AE81436745B4487F6B85C2@DM8PR09MB6677.namprd09.prod.outlook.com>
On Thu, Nov 7, 2024 at 3:59 PM Murthy Nunna <[email protected]> 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!
view thread (24+ messages) latest in thread
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected]
Subject: Re: Running rsync backups in pg15
In-Reply-To: <CANzqJaA02zeZTUB=uFPfxgJ+=NUUy1cQP3E0=3u0ssHdL6qkMA@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox