public inbox for [email protected]  

help / color / mirror / Atom feed
From: Serkan Akdemir <[email protected]>
To: Sam Stearns <[email protected]>
Cc: Pgsql-admin <[email protected]>
Cc: Avi Vallarapu <[email protected]>
Cc: Henry Ashu <[email protected]>
Subject: Re: pg_basebackup --incremental
Date: Fri, 31 Oct 2025 10:28:00 +0000
Message-ID: <[email protected]> (raw)
In-Reply-To: <CAN6TVjnoZo9p+SKTEUBhe+QGsf2tbwUEJ21fXfd3s9W-TJ5wRg@mail.gmail.com>
References: <CAN6TVjnoZo9p+SKTEUBhe+QGsf2tbwUEJ21fXfd3s9W-TJ5wRg@mail.gmail.com>

I created a script for incremental backup+merge on PostgreSQL 17+
It creates a full backup and later (next run) incremental backups. Incremental backups are merged to full backup with script, so you have always updated full backup.
Disclaimer: use it at your own risk.

Simple usage is:
# first backup should be full
pg_backup.sh --mode=fulll

# then inc
pg_backup.sh --mode=fincremental

<https://github.com/rdnkrkmz/medium-resources/blob/main/pg_backup.sh;
medium-resources/pg_backup.sh at main ยท rdnkrkmz/medium-resources<https://github.com/rdnkrkmz/medium-resources/blob/main/pg_backup.sh;
github.com<https://github.com/rdnkrkmz/medium-resources/blob/main/pg_backup.sh;
[apple-touch-icon-180x180-a80b8e11abe2.png]<https://github.com/rdnkrkmz/medium-resources/blob/main/pg_backup.sh;


On 28 Oct 2025, at 20:42, Sam Stearns <[email protected]> wrote:

Howdy,

We're running version 17.6.  Would anyone be able to point me to, or provide, some sample use cases / scripts / usage to deploy a pg_basebackup full + --incremental strategy as a backup solution, please?

This will be used temporarily as we are migrating to RDS soon which is why we're not going with pgBackRest.

Thanks,

Sam

--

Samuel Stearns
Team Lead - Database
c: 971 762 6879 | o: 971 762 6879 | DAT.com

[https://lh7-rt.googleusercontent.com/docsz/AD_4nXchMTXZiU3P-OkN7UwPyrdxiCAOkHWIArmSrehhAl-cXaYxECakb...]<https://www.dat.com/?utm_medium=email&utm_source=DAT_email_signature_link;




Attachments:

  [image/png] apple-touch-icon-180x180-a80b8e11abe2.png (20.6K, 3-apple-touch-icon-180x180-a80b8e11abe2.png)
  download | view image

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], [email protected], [email protected], [email protected], [email protected]
  Subject: Re: pg_basebackup --incremental
  In-Reply-To: <[email protected]>

* 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