Postgres Pro
Downloads
Home   >   mailing lists

Re: db recovery (FATAL 2) - Mailing list pgsql-admin

From Tom Lane
Subject Re: db recovery (FATAL 2)
Date
Msg-id 19177.1020953351@sss.pgh.pa.us
Whole thread Raw
In response to Re: db recovery (FATAL 2)  (Bojan Belovic <bbelovic@usa.net>)
Responses Missing pg_clog file  (Brian McCane <bmccane@mccons.net>)
List pgsql-admin
Tree view 
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

pgsql-admin by date:

Previous
From: Bojan Belovic
Date:
Subject: Re: db recovery (FATAL 2)
Next
From: Sonia Sanchez Diaz
Date:
Subject: SUM PROBLEM...