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 2F43D538B3 for ; Sun, 24 Apr 2005 10:30:24 -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 69464-05 for ; Sun, 24 Apr 2005 13:30:17 +0000 (GMT) Received: from tigger.fuhr.org (tigger.fuhr.org [63.214.45.158]) by svr1.postgresql.org (Postfix) with ESMTP id DDAB75374F for ; Sun, 24 Apr 2005 10:30:15 -0300 (ADT) Received: from winnie.fuhr.org (winnie.fuhr.org [10.1.0.1]) by tigger.fuhr.org (8.13.3/8.13.3) with ESMTP id j3ODUERm038073 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=OK); Sun, 24 Apr 2005 07:30:17 -0600 (MDT) (envelope-from mfuhr@winnie.fuhr.org) Received: from winnie.fuhr.org (localhost [127.0.0.1]) by winnie.fuhr.org (8.13.3/8.13.3) with ESMTP id j3ODUEoF066080; Sun, 24 Apr 2005 07:30:14 -0600 (MDT) (envelope-from mfuhr@winnie.fuhr.org) Received: (from mfuhr@localhost) by winnie.fuhr.org (8.13.3/8.13.3/Submit) id j3ODUEHg066079; Sun, 24 Apr 2005 07:30:14 -0600 (MDT) (envelope-from mfuhr) Date: Sun, 24 Apr 2005 07:30:14 -0600 From: Michael Fuhr To: Alan Donald Cc: pgsql-admin@postgresql.org Subject: Re: Database Corruption, Tables, Databases missing Message-ID: <20050424133014.GA66001@winnie.fuhr.org> References: <66a4b63105042402435842a8e4@mail.gmail.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <66a4b63105042402435842a8e4@mail.gmail.com> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.004 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200504/353 X-Sequence-Number: 17366 On Sun, Apr 24, 2005 at 03:43:20PM +0600, Alan Donald wrote: > > I have a few databases running on a postgres database server. > > Everything was working fine and then yesterday when I logged in, there > were a few databases that are missing. These tables cannot be seen in > the pg_database table. Also I cannot see these tables via pg_admin and > understandable so. Are you doing regular database-wide vacuums? What's the result of the following query? SELECT datname, age(datvacuumxid), age(datfrozenxid) FROM pg_database > Please tell me what the issue is, why it is happening and how I can I > restore the database. Without more information it's hard to say, but you might have encountered transaction ID wraparound; the above query should answer that question. See the "Routine Database Maintenance Tasks" chapter in the documentation for more info. Is it possible that the databases were dropped? -- Michael Fuhr http://www.fuhr.org/~mfuhr/