X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 9C77F9DC994 for ; Mon, 2 Jan 2006 15:05:37 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 79984-02 for ; Mon, 2 Jan 2006 15:05:35 -0400 (AST) Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id 18F0D9DC81E for ; Mon, 2 Jan 2006 15:05:33 -0400 (AST) Received: from exchange.meridiascapital.com (exchange.meridiascapital.com [65.90.55.78]) by svr4.postgresql.org (Postfix) with ESMTP id ECBB95AF032 for ; Mon, 2 Jan 2006 19:05:33 +0000 (GMT) Received: from 192.168.19.129 ([192.168.19.129]) by atherton-ex-01.meridias.local ([192.168.8.78]) with Microsoft Exchange Server HTTP-DAV ; Mon, 2 Jan 2006 19:05:30 +0000 Received: from sharp by ATHERTON-EX-01; 02 Jan 2006 12:05:30 -0700 Subject: Emergency - Need assistance From: warren little To: pgsql-admin@postgresql.org Content-Type: text/plain Content-Transfer-Encoding: 7bit Date: Mon, 02 Jan 2006 12:05:29 -0700 Message-Id: <1136228730.16094.12.camel@sharp> Mime-Version: 1.0 X-Mailer: Evolution 2.2.2 (2.2.2-5) X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.001 required=5 tests=[UNPARSEABLE_RELAY=0.001] X-Spam-Score: 0.001 X-Spam-Level: X-Archive-Number: 200601/16 X-Sequence-Number: 20104 I received the following error message when trying to copy a table from one database to another on the same cluster: pg_dump: The command was: FETCH 100 FROM _pg_dump_cursor pg_restore: [custom archiver] could not read data block -- expected 1, got 0 pg_restore: *** aborted because of error The table contains a bytea column which houses pdf documents. Is this a sign of corrupted data and if so would setting "zero_damaged_pages = true" allow the copy to proceed? The table is about 25GB in size and takes a long time to dump/restore and I'm running out of time to get the cluster back into production. note running: PostgreSQL 8.1beta4 on x86_64-unknown-linux-gnu, compiled by GCC gcc (GCC) 3.4.4 20050721 (Red Hat 3.4.4-2)" -- Warren Little CTO Meridias Capital Inc ph 866.369.7763