X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 499DD52D91 for ; Sun, 17 Apr 2005 14:26:00 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 40744-04 for ; Sun, 17 Apr 2005 17:25:55 +0000 (GMT) Received: from exit1.i-55.com (exit1.i-55.com [208.231.96.22]) by svr1.postgresql.org (Postfix) with ESMTP id 05165534E2 for ; Sun, 17 Apr 2005 14:25:54 -0300 (ADT) Received: from simpsonnew (dsl-209-205-186-247.i-55.com [209.205.186.247]) by exit1.i-55.com (8.11.7/8.11.4) with SMTP id j3HHPu202338 for ; Sun, 17 Apr 2005 12:25:56 -0500 From: "Simpson" To: Subject: Corrupt DB Date: Sun, 17 Apr 2005 12:27:35 -0500 Message-ID: MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook IMO, Build 9.0.2416 (9.0.2911.0) Importance: Normal X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.07 tagged_above=0 required=5 tests=DNS_FROM_AHBL_RHSBL X-Spam-Level: X-Archive-Number: 200504/224 X-Sequence-Number: 17237 Greetings, I am running Postgresql 8.0 on "Linux xxx 2.4.18-14 #1 Wed Sep 4 12:13:11 EDT 2002 i686 athlon i386 GNU/Linux" and while loading data my program received: DBD::Pg::db do failed: server closed the connection unexpectedly ... Now I can't access any data in the DB, not even the \d command: mydb=# \d ERROR: could not identify an ordering operator for type name HINT: Use an explicit ordering operator or modify the query. I tried vacuum: mydb=# vacuum; ERROR: could not open relation 1663/12649295/16396: No such file or directory What would be the best way to fix this? How would I determine what caused the corruption and prevent it from happening again? Thanks for any assistance, Drew.