From: PG Bug reporting form <noreply@postgresql.org>
To: pgsql-bugs@lists.postgresql.org
Cc: cpond@telecomassets.com
Subject: BUG #16458: pg_restore lists data in corrupted backup files without checking if data exists
Date: Mon, 25 May 2020 00:02:58 +0000
Message-ID: <16458-e5b9c1930f71db9b@postgresql.org> (raw)
The following bug has been logged on the website:
Bug reference: 16458
Logged by: Cris Pond
Email address: cpond@telecomassets.com
PostgreSQL version: 10.12
Operating system: Ubuntu 18.04.4 LTS
Description:
I'm coming across a similar problem to bug #6127 here:
https://www.postgresql.org/message-id/CAD6QHKQdqgi%3DVidKM6Erj9Vi8Z6ff_bBncqtt-hJX3Z%2Bn9KTyQ%40mail...
We have a backup file that appears to be corrupted which will restore schema
and some data, but will not restore all data, giving the "pg_restore:
[custom archiver] could not read from input file: end of file" error on the
command line and "ERROR: unexpected message type 0x58 during COPY from
stdin" in the log.
It appears it starts to copy from standard input and then just dies. The
backup was apparently dumped in custom format.
My apologies if there is already a way to do this, but could pg_restore do a
basic check on the actual data in the dump file to make sure it's there on a
--list query? The corrupt dump file has never reported errors on a list,
and reports "TABLE DATA" in the affected tables.
We were relying on that output to be sure our backups were working properly,
and it's extremely frustrating that the data are gone now that we really
need them.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-bugs@postgresql.org
Cc: noreply@postgresql.org, pgsql-bugs@lists.postgresql.org, cpond@telecomassets.com
Subject: Re: BUG #16458: pg_restore lists data in corrupted backup files without checking if data exists
In-Reply-To: <16458-e5b9c1930f71db9b@postgresql.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox