Re: Vacuum full?

>>>>> "TL" == Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> writes:

TL> Vivek Khera <khera(at)kcilink(dot)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(at)kciLink(dot)com Rockville, MD +1-240-453-8497
AIM: vivekkhera Y!: vivek_khera http://www.khera.org/~vivek/