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 5244CD1B175 for ; Fri, 11 Jun 2004 18:35:52 -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 39632-05 for ; Fri, 11 Jun 2004 21:35:45 +0000 (GMT) Received: from bramble.mmrd.com (unknown [65.217.53.66]) by svr1.postgresql.org (Postfix) with ESMTP id EC49FD1B169 for ; Fri, 11 Jun 2004 18:35:41 -0300 (ADT) Received: from thorn.mmrd.com (thorn.mmrd.com [172.25.10.100]) by bramble.mmrd.com (8.12.8/8.12.8) with ESMTP id i5BK2x9U019827; Fri, 11 Jun 2004 16:03:01 -0400 Received: from gnvex001.mmrd.com (gnvex001.mmrd.com [10.225.10.110]) by thorn.mmrd.com (8.11.6/8.11.6) with ESMTP id i5BLZGN02736; Fri, 11 Jun 2004 17:35:17 -0400 Received: from camel.mmrd.com ([172.25.5.213]) by gnvex001.mmrd.com with SMTP (Microsoft Exchange Internet Mail Service Version 5.5.2657.72) id LP85KD8N; Fri, 11 Jun 2004 17:35:14 -0400 Subject: Re: Corrupted or deleted pg_tables From: Robert Treat To: Curtis Klumas Cc: pgsql-admin@postgresql.org, Jonathan Yee In-Reply-To: References: Content-Type: text/plain Content-Transfer-Encoding: 7bit X-Mailer: Ximian Evolution 1.0.8 Date: 11 Jun 2004 17:35:16 -0400 Message-Id: <1086989716.9266.1186.camel@camel> Mime-Version: 1.0 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/152 X-Sequence-Number: 13812 On Tue, 2004-06-08 at 21:08, Curtis Klumas wrote: > > 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. > My guess is that you have hit xid wrap around. Try vacuuming full template1 and see if your info starts to reappear. Also watch to see if it tells you some other db's need vacuum. Robert Treat -- Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL