Re: Vacuum full? - Mailing list pgsql-general

From Tom Lane
Subject Re: Vacuum full?
Date
Msg-id 1585.1037651664@sss.pgh.pa.us
Whole thread Raw
In response to Re: Vacuum full?  (Vivek Khera <khera@kcilink.com>)
Responses Re: Vacuum full?  (Vivek Khera <khera@kcilink.com>)
List pgsql-general
Vivek Khera <khera@kcilink.com> writes:
> Curiously, last time I did this (July 4), I got the same error, so I
> really doubt it is an open transaction, unless such a thing survives
> db shutdown and restart ;-)

Yes, there is one known variant that survives a shutdown.  I am certain
that that form of the problem is patched in 7.2.3-RH (Red Hat's
release), but don't recall if it's in the community 7.2.3 release or
not.  In any case the fix is in 7.3, along with fixes for other cases
that can produce the same error message.

            regards, tom lane

pgsql-general by date:

Previous
From: Vivek Khera
Date:
Subject: Re: Vacuum full?
Next
From: Vivek Khera
Date:
Subject: Re: Postfix and Postgres