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 2C251D1B345 for ; Tue, 8 Jun 2004 22:09:06 -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 91627-01 for ; Wed, 9 Jun 2004 01:09:05 +0000 (GMT) Received: from S1056ZYM.RANDRINC.COM (unknown [63.87.7.230]) by svr1.postgresql.org (Postfix) with ESMTP id F1CECD1B276 for ; Tue, 8 Jun 2004 22:08:59 -0300 (ADT) Received: from youriogzcdkw65([10.1.1.108]) by S1056ZYM.RANDRINC.COM (IBM OS/400 SMTP V05R01M00) with TCP; Tue, 8 Jun 2004 18:07:17 +0000 From: "Curtis Klumas" To: Cc: "Jonathan Yee" Subject: Re: Corrupted or deleted pg_tables Date: Tue, 8 Jun 2004 18:08:58 -0700 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.2910.0) Importance: Normal X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200406/109 X-Sequence-Number: 13769 We have a database that we manage through Webmin and today, the entires for the databases dissappeared from webmin. Going in through psql we could see our data in tables still intact, and have a copy of the directory structure. Is thier anyway to extract data and reconstruct a new database? We tried pg_dump but had a host of errors. --------------------------------------------------- Curtis Klumas Randr, Inc. 909-205-9138 (cell) 909-669-3427 (office) curtis@mail.randrinc.com ---------------------------------------------------