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 <[EMAIL PROTECTED]> ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
