From: Tom Lane <tgl@sss.pgh.pa.us>
To: Achilleas Mantzios <achill@matrix.gatewaynet.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: pg_dump: Error message from server: ERROR: compressed data is corrupt
Date: Fri, 23 Apr 2010 10:05:46 -0400
Message-ID: <7928.1272031546@sss.pgh.pa.us> (raw)
In-Reply-To: <201004231454.43104.achill@matrix.gatewaynet.com>
References: <201004231454.43104.achill@matrix.gatewaynet.com>
Achilleas Mantzios <achill@matrix.gatewaynet.com> writes:
> Then i did
> # CREATE TABLE mail_entity2 AS SELECT * FROM mail_entity;
> which went fine
> but, for some crazy reason, pg_dump on mail_entity2 also results to an error:
> srv:~> pg_dump -t mail_entity2 > /dev/null
> pg_dump: SQL command failed
> pg_dump: Error message from server: ERROR: compressed data is corrupt
The create/select would not have bothered to decompress any
inline-compressed datums, so the corrupted data went right over to the
new table. I think you'll have to engage in another round of
divide-and-conquer to locate the specific row or rows with a corrupted
value.
regards, tom lane
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-admin@postgresql.org
Cc: tgl@sss.pgh.pa.us, achill@matrix.gatewaynet.com
Subject: Re: pg_dump: Error message from server: ERROR: compressed data is corrupt
In-Reply-To: <7928.1272031546@sss.pgh.pa.us>
* 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