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@sss.pgh.pa.us> wrote:
> Bojan Belovic <bbelovic@usa.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@postgresql.org so that your
> message can get through to the mailing list cleanly