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 82999D1B374 for ; Wed, 9 Jun 2004 11:27:12 -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 23871-09 for ; Wed, 9 Jun 2004 14:27:15 +0000 (GMT) Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by svr1.postgresql.org (Postfix) with ESMTP id B611DD1B37B for ; Wed, 9 Jun 2004 11:27:10 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.11/8.12.11) with ESMTP id i59EQtbG020833; Wed, 9 Jun 2004 10:26:56 -0400 (EDT) To: "Curtis Klumas" Cc: pgsql-admin@postgresql.org, "Jonathan Yee" Subject: Re: Corrupted or deleted pg_tables In-reply-to: References: Comments: In-reply-to "Curtis Klumas" message dated "Tue, 08 Jun 2004 18:08:58 -0700" Date: Wed, 09 Jun 2004 10:26:55 -0400 Message-ID: <20832.1086791215@sss.pgh.pa.us> From: Tom Lane 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/115 X-Sequence-Number: 13775 "Curtis Klumas" writes: > 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. Like what? The only specific information you've provided here is that things still work from psql ... regards, tom lane