Re: HELP!!! The WAL Archive is taking up all space

From: John R Pierce <pierce(at)hogranch(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: HELP!!! The WAL Archive is taking up all space
Date: 2015-12-09 19:38:18
Message-ID: 5668832A.1070203@hogranch.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2015-12-09 20:31:35 Re: Deletion Challenge
Previous Message Adrian Klaver 2015-12-09 19:22:29 Re: HELP!!! The WAL Archive is taking up all space