Re: Vacuum full?

>>>>> "TL" == Tom Lane <tgl@sss.pgh.pa.us> writes:

TL> 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 ;-)

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

Wow... even if I cleanly shut down all my applications, then shut down
the server I can run into this?

I guess 7.3 can't come soon enough! ;-)

I suppose it is high time to pull down the 7.3b5 and give it a whirl
on the development box.

Thanks.

--
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Vivek Khera, Ph.D.                Khera Communications, Inc.
Internet: khera@kciLink.com       Rockville, MD       +1-240-453-8497
AIM: vivekkhera Y!: vivek_khera   http://www.khera.org/~vivek/