Re: pg_combinebackup failure

From: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
To: Kouber Saparev <kouber(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: pg_combinebackup failure
Date: 2025-06-24 15:48:53
Message-ID: 5746f172-e628-4c10-b7fe-74e626946a90@aklaver.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 6/24/25 08:38, Kouber Saparev wrote:
> Barman is involved indeed, its version is 3.14. The command: "barman
> backup xxx --incremental latest".

I don't use Barman and I am still figuring out incremental backups, so
what I say should be taken lightly.

From here:

https://docs.pgbarman.org/release/3.14.1/user_guide/backup.html#block-level-incremental-backup

"Alternatively, you can use last-full or latest-full to reference the
most recent eligible full backup in the catalog."

Not sure that latest by itself will work.

>
> PostgreSQL is version 17.3.
>
> На вт, 24.06.2025 г. в 18:26 Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com
> <mailto:adrian(dot)klaver(at)aklaver(dot)com>> написа:
>
> On 6/24/25 02:31, Kouber Saparev wrote:
> > Hello,
> >
> > We are trying to use pg_combinebackup but eventually it fails with:
>
> What is the command you are using to take the incremental backups?
>
> What version of Postgres are you taking the incremental backups from?
>
> Given the naming below, is Barman involved in this?
>
> If Barman is involved what version and what command is being used?
>
> >
> > pg_combinebackup --debug --dry-run
> > --output=/barman-backup/barman-data/test_combine
> 20250616T140003/data
> > 20250617T090005/data
> >
> > ...
> >
> > pg_combinebackup: would copy
> > "20250616T140003/data/base/16420/2136674204" to
> > "/barman-backup/barman-data/test_combine/base/16420/2136674204"
> > pg_combinebackup: would copy
> > "20250616T140003/data/base/16420/2542449085" to
> > "/barman-backup/barman-data/test_combine/base/16420/2542449085"
> > pg_combinebackup: error: file
> > "20250617T090005/data/base/16420/INCREMENTAL.4085177931.76" has
> > truncation block length 9501840 in excess of segment size 131072
> >
> > Any idea what's wrong?
> >
> > --
> > Kouber Saparev
>
> --
> Adrian Klaver
> adrian(dot)klaver(at)aklaver(dot)com <mailto:adrian(dot)klaver(at)aklaver(dot)com>
>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Greg Sabino Mullane 2025-06-24 23:20:21 Re: password rules
Previous Message Kouber Saparev 2025-06-24 15:38:59 Re: pg_combinebackup failure