Στις Friday 23 April 2010 17:05:46 ο/η Tom Lane έγραψε: > Achilleas Mantzios <ach...@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.
We just removed one memory SIM, and the problem went away. It must have been a problem caused by on the fly memory hardware error rather than actual corrupted data on the disk. I have a decent dump now, thank you a lot. > > regards, tom lane > -- Achilleas Mantzios -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin