Postgres Pro
Downloads
Home   >   mailing lists

Re: HELP!!! The WAL Archive is taking up all space - Mailing list pgsql-general

From John R Pierce
Subject Re: HELP!!! The WAL Archive is taking up all space
Date
Msg-id 5668832A.1070203@hogranch.com
Whole thread Raw
In response to HELP!!! The WAL Archive is taking up all space  (FattahRozzaq <ssoorruu@gmail.com>)
Responses Re: HELP!!! The WAL Archive is taking up all space  (FattahRozzaq <ssoorruu@gmail.com>)
List pgsql-general
Tree view 
On 12/8/2015 4:55 PM, FattahRozzaq wrote:
> ...I want to limit the total size use by WAL archive to around 200-400 GB...?

for what purpose are you keeping a wal archive ?

if its for PITR (point in time recovery), you need ALL WAL records since
the start of a base backup up to the point in time at which you wish to
recover.


--
john r pierce, recycling bits in santa cruz

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: HELP!!! The WAL Archive is taking up all space
Next
From: Adrian Klaver
Date:
Subject: Re: Deletion Challenge