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 73C805E46F3 for ; Wed, 25 Aug 2004 22:56:53 -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 35800-04 for ; Thu, 26 Aug 2004 01:56:48 +0000 (GMT) Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by svr1.postgresql.org (Postfix) with ESMTP id 3D86B5E46EC for ; Wed, 25 Aug 2004 22:56:46 -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 i7Q1uop4010929; Wed, 25 Aug 2004 21:56:50 -0400 (EDT) To: Andrew Farmer Cc: pgsql-admin@postgresql.org Subject: Re: 7.3.4 Table corruption In-reply-to: <412BEE3D.8070409@andrewfarmer.com> References: <412BEE3D.8070409@andrewfarmer.com> Comments: In-reply-to Andrew Farmer message dated "Wed, 25 Aug 2004 10:41:17 +0900" Date: Wed, 25 Aug 2004 21:56:50 -0400 Message-ID: <10928.1093485410@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: 200408/254 X-Sequence-Number: 14649 Andrew Farmer writes: > 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? This strikes me as a real good way to shoot yourself in the foot ;-). Better take a backup and be prepared to restore from it. And I'd suggest experimenting in a scratch installation before you try it for real. Having said that, I think it would work, if your "clean database" is another DB in the same cluster (you could *not* copy from data prepared under a different postmaster). And you'll need to copy all the indexes on that table, and its toast table and toast table index if it has one. And shut down the postmaster while you do the copying. regards, tom lane