Re: vacuuming template0 gave ERROR - Mailing list pgsql-admin

From Gourish Singbal
Subject Re: vacuuming template0 gave ERROR
Date
Msg-id 674d1f8a0512262320x7151c4e5ka87b535599b891ee@mail.gmail.com
Whole thread Raw
In response to Re: vacuuming template0 gave ERROR  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-admin
 
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

pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: vacuuming template0 gave ERROR
Next
From: "sandhya"
Date:
Subject: reg:reading files from the DB