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 7FCB4329C7B for ; Tue, 14 Sep 2004 03:30:41 +0100 (BST) 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 53473-02 for ; Tue, 14 Sep 2004 02:30:33 +0000 (GMT) Received: from nyetwork.org (nyetwork.org [64.251.84.38]) by svr1.postgresql.org (Postfix) with ESMTP id 55EAE329C67 for ; Tue, 14 Sep 2004 03:30:36 +0100 (BST) Received: from [127.0.0.1] (glider.psdhost.net [64.251.84.4]) by nyetwork.org (Postfix) with ESMTP id 8255E21E5F9 for ; Mon, 13 Sep 2004 19:30:18 -0700 (PDT) Message-ID: <414657CA.5040809@nyetwork.org> Date: Mon, 13 Sep 2004 19:30:34 -0700 From: Wim Kerkhoff User-Agent: Mozilla Thunderbird 0.7.3 (Windows/20040803) X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: pg_class / missing tables X-Enigmail-Version: 0.84.0.0 X-Enigmail-Supports: pgp-inline, pgp-mime Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit 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: 200409/113 X-Sequence-Number: 14816 I'm trying to recover a database where some tables 'went missing'... Short story: server was rebooted without being shut down properly, upon bootup PostgreSQL (7.4.3) starts fine, but a couple of data tables (along with their associated indexes and sequences) are gone. Other tables are still there. The missing tables aren't listed in \d or in the pg_class table, but according to the sizes of the numbered files in /var/lib/postgres/data/base/142772, the raw files must still be there. What's interested is that if I try: CREATE TABLE missing_table_name (foo int); It does complain that the table already exists... What's happening here? Many thanks, Wim