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@xxxxxxxxxxx, 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
