Received: from localhost (unknown [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id DBC4E2E0052 for ; Thu, 29 Nov 2007 11:21:02 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024) with ESMTP id 09005-04 for ; Thu, 29 Nov 2007 11:20:53 -0400 (AST) Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id 590642E0045 for ; Thu, 29 Nov 2007 11:20:59 -0400 (AST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.1/8.14.1) with ESMTP id lATFKuFG013499; Thu, 29 Nov 2007 10:20:56 -0500 (EST) To: Darren Reed cc: pgsql-admin@postgresql.org Subject: Re: Why dos select work when pg_dump fails? In-reply-to: <474E7327.1010805@fastmail.net> References: <474E7327.1010805@fastmail.net> Comments: In-reply-to Darren Reed message dated "Thu, 29 Nov 2007 00:07:03 -0800" Date: Thu, 29 Nov 2007 10:20:56 -0500 Message-ID: <13498.1196349656@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200711/242 X-Sequence-Number: 27485 Darren Reed writes: > For whatever reason, I'm back dealing with corrupted tables but > curiously while this fails: > pg_dump -U postgres -a -t table -f /data/table.dump > this works: > psql -U postgres -A -o /data/table.dump -c "SELECT * FROM table;" pg_dump is evidently failing while trying to get the definitions of that table's indexes. Does "\d table" work? regards, tom lane