Re: db recovery (FATAL 2)

Just to make sure - given that there is plenty of space available (database is
slightly larger than 1GB and there is almost 10GB free), there should be no
problem with vacuum?
Or should I upgrade regardless? (I generally like to keep stable system
stable, unless I know there is a specific reason why I should change things in
the environment)

Thanks a lot,

Bojan

Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> Bojan Belovic <bbelovic(at)usa(dot)net> writes:
> > One quick question - you mentioned I should upgrade to 7.1.3 beofre I run
> > vacuum again. What are the known problems that "ask" for this?
>
> WAL growth. My original theory was that you'd run out of disk space
> because of a VACUUM trying to do a huge amount of work. In 7.1.2
> the WAL can grow arbitrarily large during a long transaction...
>
> There are some other not-unimportant bug fixes in 7.1.3 too, but that's
> the one I was thinking of.
>
> regards, tom lane
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly