El día lunes, agosto 09, 2021 a las 01:32:58p. m. -0700, Adrian Klaver escribió:
> https://www.postgresql.org/docs/13/app-pgverifybackup.html
>
> "pg_verifybackup is used to check the integrity of a database cluster backup
> taken using pg_basebackup against a backup_manifest generated by the server
> at the time of the backup. The backup must be stored in the "plain" format;
> a "tar" format backup can be checked after extracting it."
I've studied now the fine docs again and have some additional questions. The
backup was done fine to the directory /data/postgresql133/backup-20210810-1
which contains now:
$ ls -l
total 717252
-rw------- 1 postgres postgres 430331 Aug 10 08:54 backup_manifest
-rw------- 1 postgres postgres 734006592 Aug 10 08:54 base.tar.gz
-rw------- 1 postgres postgres 17667 Aug 10 08:54 pg_wal.tar.gz
I un-tar'ed the two archives with
$ tar xzf base.tar.gz
$ tar xzf pg_wal.tar.gz
And then I run pg_verifybackup it gives the following errors:
$ pg_verifybackup /data/postgresql133/backup-20210810-1
pg_verifybackup: error: "0000000100000000000000D9" is present on disk but not in the manifest
pg_verifybackup: error: "pg_wal.tar.gz" is present on disk but not in the manifest
pg_verifybackup: error: "base.tar.gz" is present on disk but not in the manifest
pg_verifybackup: error: "archive_status/0000000100000000000000D9.done" is present on disk but not in the manifest
pg_waldump: fatal: could not find any WAL file
pg_verifybackup: error: WAL parsing failed for timeline 1
The two messages about the present of pg_wal.tar.gz and base.tar.gz are
clear. One could move the archives out of the sight of pg_verifybackup.
But the others are unclear to me. The files 0000000100000000000000D9 and
archive_status/0000000100000000000000D9.done are part of pg_wal.tar.gz
written by pg_basebackup:
tar tvf pg_wal.tar.gz
-rw------- postgres/postgres 16777216 2021-08-10 08:52 0000000100000000000000D9
-rw------- postgres/postgres 0 2021-08-10 08:54 archive_status/0000000100000000000000D9.done
About WAL the file backup_manifest contains only:
"WAL-Ranges": [
{ "Timeline": 1, "Start-LSN": "0/D9000028", "End-LSN": "0/D9000138" }
],
What is the problem here or what I've missed?
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