X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 480699DC81E for ; Tue, 27 Dec 2005 03:16:24 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 91039-05 for ; Tue, 27 Dec 2005 03:16:21 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id 0ACEF9DC80E for ; Tue, 27 Dec 2005 03:16:18 -0400 (AST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.1/8.13.1) with ESMTP id jBR7GIoO020441; Tue, 27 Dec 2005 02:16:18 -0500 (EST) To: Gourish Singbal cc: "pgsql-admin@postgresql.org" Subject: Re: vacuuming template0 gave ERROR In-reply-to: <674d1f8a0512262305g3e2bfb81t420482ea981b6e14@mail.gmail.com> References: <674d1f8a0512260334g3b72c635m7d46ab457a8f2694@mail.gmail.com> <9822.1135612972@sss.pgh.pa.us> <674d1f8a0512262305g3e2bfb81t420482ea981b6e14@mail.gmail.com> Comments: In-reply-to Gourish Singbal message dated "Tue, 27 Dec 2005 12:35:43 +0530" Date: Tue, 27 Dec 2005 02:16:18 -0500 Message-ID: <20440.1135667778@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.047 required=5 tests=[AWL=0.047] X-Spam-Score: 0.047 X-Spam-Level: X-Archive-Number: 200512/314 X-Sequence-Number: 20034 Gourish Singbal writes: > I got the followign Erorr when i tried to trucate the table. > /usr/local/pgsql/bin/postgres -D data -O -o standalone_log template0 > 2005-12-26 22:48:12 ERROR: expected one dependency record for TOAST table, > found 0 [ raised eyebrow... ] Probably time to pg_dump, initdb, reload. You seem to be suffering multiple problems. If you aren't aware of any catastrophe that would explain all these holes in your DB, then it's also time to start running some hardware diagnostics ... regards, tom lane