Re: Out of space situation and WAL log pre-allocation (was Tablespaces) - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Out of space situation and WAL log pre-allocation (was Tablespaces)
Date
Msg-id 8478.1078289703@sss.pgh.pa.us
Whole thread Raw
In response to Re: Out of space situation and WAL log pre-allocation (was  (Joe Conway <mail@joeconway.com>)
Responses Re: Out of space situation and WAL log pre-allocation (was  (Joe Conway <mail@joeconway.com>)
List pgsql-hackers
Joe Conway <mail@joeconway.com> writes:
> Tom Lane wrote:
>> facing the possibility of an out-of-WAL-space panic.  I suspect that we
>> cannot really do anything about that, but it's annoying.  Any bright
>> ideas out there?

> Maybe specify an archive location (that of course could be on a separate 
> partition) that the external archiver should check in addition to the 
> normal WAL location. At some predetermined interval, push WAL log 
> segments no longer needed to the archive location.

Does that really help?  The panic happens when you fill the "normal" and
"archive" partitions, how's that different from one partition?
        regards, tom lane


pgsql-hackers by date:

Previous
From: Gavin Sherry
Date:
Subject: Re: Tablespaces
Next
From: Tom Lane
Date:
Subject: Re: Tablespaces