Request a Demo
Home   >   mailing lists

Re: pg_basebackup --incremental - Mailing list pgsql-admin

From Serkan Akdemir
Subject Re: pg_basebackup --incremental
Date
Msg-id 5E1A5137-37A3-4F83-880F-0C17DDA1F143@hotmail.com
Whole thread Raw
In response to pg_basebackup --incremental  (Sam Stearns <sam.stearns@dat.com>)
Responses Re: pg_basebackup --incremental
List pgsql-admin
Tree view
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



On 28 Oct 2025, at 20:42, Sam Stearns <sam.stearns@dat.com> 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



Attachment

pgsql-admin by date:

Previous
From: Shardul Borhade
Date:
Subject: Re: Question on pg_stat_io showing zero reads/writes for I/O workers
Next
From: Sam Stearns
Date:
Subject: Re: pg_basebackup --incremental