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 B41EE5E46F3 for ; Tue, 24 Aug 2004 22:42:09 -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 24005-10 for ; Wed, 25 Aug 2004 01:42:09 +0000 (GMT) Received: from aibo.runbox.com (aibo.runbox.com [193.71.199.94]) by svr1.postgresql.org (Postfix) with ESMTP id 3D36A5E46C3 for ; Tue, 24 Aug 2004 22:42:05 -0300 (ADT) Received: from [10.9.9.11] (helo=fifi.runbox.com) by bolivar.runbox.com with esmtp (Exim 4.24) id 1Bzmnh-0007QE-41 for pgsql-admin@postgresql.org; Wed, 25 Aug 2004 03:42:09 +0200 Received: from [221.242.208.180] (helo=[192.168.0.3]) by fifi.runbox.com with asmtp (uid:182597) (Exim 4.24) id 1Bzmng-0001Sb-OI for pgsql-admin@postgresql.org; Wed, 25 Aug 2004 03:42:09 +0200 Message-ID: <412BEE3D.8070409@andrewfarmer.com> Date: Wed, 25 Aug 2004 10:41:17 +0900 From: Andrew Farmer User-Agent: Mozilla Thunderbird 0.6 (X11/20040729) X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: 7.3.4 Table corruption Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Sender: 182597 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: 200408/250 X-Sequence-Number: 14645 I'm running a 7.3.4 on a RedHat 7.2 i686 box. I take daily backups of my application's database, and last week it failed on one of the tables. After some checking I found that the rest of the data was ok, just a large number of tuples on one table were corrupt. I'm pretty sure it's table corruption, as a REINDEX does not solve the problem, and I can't COPY data from the table. I have backups I can use, but I only want to restore this one table, which would not normally be a big problem, as I can just pull the relevant commands out of the dump file. But there are a lot of connections through rules and references from the broken table to other tables, so I can't simply truncate this table and reload it, I would have to reload a large number of other tables as well. Something I don't really want to do, as I could potentially lose more data. My question is, if I load the good dump into a clean database, and then find the underlying file that represents the broken table and copy it over the top of the broken table, am I likely to face any big problems? Thanks Andrew