Re: vacumm error - Mailing list pgsql-bugs

From Rod Taylor
Subject Re: vacumm error
Date
Msg-id 1038321803.2508.4.camel@jester
Whole thread Raw
In response to vacumm error  (Stefanos Harhalakis <v13@it.teithe.gr>)
Responses Re: vacumm error
List pgsql-bugs
On Fri, 2002-11-22 at 15:51, Stefanos Harhalakis wrote:
> I'm running postgresql 7.2.1 on linux.
>
> I cannot run vacuumm on a table in a database i'm running for about 7 months.
> I get:
>
> ERROR:  No one parent tuple was found

Your best bet, since you've crashed with fsync off, is to dump and
reload the database.  This should clean up any data issues you currently
have -- assuming pg_dump functions on it.

That said, 7.2.3 has several vacuum fixes, but I don't think they'll fix
your problem.

--
Rod Taylor <rbt@rbt.ca>

pgsql-bugs by date:

Previous
From: "Rison, Stuart"
Date:
Subject: [SQL/BUGS] (possible) inconsistent behaviour of timestamp?
Next
From: Rod Taylor
Date:
Subject: Re: RULE: ON DELETE doesn't stack deletes