Skip site navigation (1) Skip section navigation (2)

Re: vacuuming template0 gave ERROR

From: Gourish Singbal <gourish(at)gmail(dot)com>
To: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: vacuuming template0 gave ERROR
Date: 2005-12-27 07:20:10
Message-ID: 674d1f8a0512262320x7151c4e5ka87b535599b891ee@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-adminpgsql-performance
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(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>
> Gourish Singbal <gourish(at)gmail(dot)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

In response to

pgsql-performance by date

Next:From: Dawid KuroczkoDate: 2005-12-27 07:24:45
Subject: Re: What's the best hardver for PostgreSQL 8.1?
Previous:From: Tom LaneDate: 2005-12-27 07:16:18
Subject: Re: vacuuming template0 gave ERROR

pgsql-admin by date

Next:From: sandhyaDate: 2005-12-27 08:26:52
Subject: reg:reading files from the DB
Previous:From: Tom LaneDate: 2005-12-27 07:16:18
Subject: Re: vacuuming template0 gave ERROR

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group