(13.1) pg_basebackups ./. pg_verifybackup - Mailing list pgsql-general

From Matthias Apitz
Subject (13.1) pg_basebackups ./. pg_verifybackup
Date
Msg-id YRGMyLtdVS2jRlWd@c720-r368166
Whole thread Raw
Responses Re: (13.1) pg_basebackups ./. pg_verifybackup
List pgsql-general
Hello,

We do backups with something like:

$ pg_basebackup -U ${DBSUSER} -Ft -z -D ${BACKUPDIR}-${DATE}-${NUM}

and they seems to work fine:

$ ls -l backup-20210809-1/
total 7656108
-rw------- 1 postgres postgres    4191873 Aug  9 14:19 backup_manifest
-rw------- 1 postgres postgres 7835635150 Aug  9 14:19 base.tar.gz
-rw------- 1 postgres postgres      17671 Aug  9 14:19 pg_wal.tar.gz

But, if I verify the backup with

$ pg_verifybackup /data/postgresql13/backup-20210809-1

it gives thousands of error messages like

pg_verifybackup: error: "base/1032792/1034229" is present in the manifest but not on disk
pg_verifybackup: error: "base/1076178/1101524" is present in the manifest but not on disk

and at the end:

pg_waldump: error: could not open directory "/data/postgresql13/backup-20210809-1/pg_wal": No such file or directory
pg_verifybackup: error: WAL parsing failed for timeline 1

The base files are there:

$ find /data/postgresql13 -name 1101524
/data/postgresql13/data/base/1076178/1101524

$ find /data/postgresql13 -name pg_wal
/data/postgresql13/data/pg_wal

What we do wrong here with pg_verifybackup?

Thanks

    matthias

-- 
Matthias Apitz, ✉ guru@unixarea.de, http://www.unixarea.de/ +49-176-38902045
Public GnuPG key: http://www.unixarea.de/key.pub
27.7.1900: Kaiser Wilhelm II Deutsches Ostasiatisches Expeditionskorps,   target China
02.8.2021: Deutsche Kriegsministerin Kramp-Karrenbauer Fregatte "Bayern", target China



pgsql-general by date:

Previous
From: Bryn Llewellyn
Date:
Subject: PL/pgSQL: Spurious 22P02 error on "select col into var" when col is user-defined type
Next
From: Adrian Klaver
Date:
Subject: Re: (13.1) pg_basebackups ./. pg_verifybackup