Postgres Pro
Downloads
Home   >   mailing lists

Re: [HACKERS] Automatic cleanup of oldest WAL segments withpg_receivexlog - Mailing list pgsql-hackers

From Peter Eisentraut
Subject Re: [HACKERS] Automatic cleanup of oldest WAL segments withpg_receivexlog
Date
Msg-id f8d97d0c-be69-038b-621f-0dda6fa629e8@2ndquadrant.com
Whole thread Raw
In response to Re: [HACKERS] Automatic cleanup of oldest WAL segments with pg_receivexlog  (Robert Haas <robertmhaas@gmail.com>)
Responses Re: [HACKERS] Automatic cleanup of oldest WAL segments with pg_receivexlog
List pgsql-hackers
Tree view 
On 3/6/17 17:16, Robert Haas wrote:
> What if we told pg_receivewal (or pg_receivexlog, whatever that is) a
> maximum number of segments to retain before removing old ones?  Like
> pg_receivewal --limit-retained-segments=50GB, or something like that.

That would be doable, but would it solve anyone's problem?  I think
pg_receivewal retention would usually be governed either by the
available base backups, or by some time-based business metric.

-- 
Peter Eisentraut              http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: [HACKERS] Parallel bitmap heap scan
Next
From: Dilip Kumar
Date:
Subject: Re: [HACKERS] Parallel bitmap heap scan