From: Gourish Singbal <gourish@gmail.com>
To: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: Re: vacuuming template0 gave ERROR
Date: Tue, 27 Dec 2005 12:50:10 +0530
Message-ID: <674d1f8a0512262320x7151c4e5ka87b535599b891ee@mail.gmail.com> (raw)
In-Reply-To: <20440.1135667778@sss.pgh.pa.us>
References: <674d1f8a0512260334g3b72c635m7d46ab457a8f2694@mail.gmail.com>
<9822.1135612972@sss.pgh.pa.us>
<674d1f8a0512262305g3e2bfb81t420482ea981b6e14@mail.gmail.com>
<20440.1135667778@sss.pgh.pa.us>
Thanks a million tom,
But guess what we think alike, have taken the dump and am in to process of
restoring it right now.
thanks for the help.
On 12/27/05, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>
> Gourish Singbal <gourish@gmail.com> 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
>
--
Best,
Gourish Singbal
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: gourish@gmail.com, pgsql-admin@postgresql.org
Subject: Re: vacuuming template0 gave ERROR
In-Reply-To: <674d1f8a0512262320x7151c4e5ka87b535599b891ee@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox