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

On 12/09/2015 11:15 AM, Alan Hodgson wrote:
> On Wednesday, December 09, 2015 07:55:09 AM FattahRozzaq wrote:
>> archive_mode = on
>> archive_command = 'cp -i %p /home/postgres/archive/master/%f'
>>
>>
>> The WAL archive folder is at /home/postgres/archive/master/, right?
>> This directory consumes around 750GB of Disk-1.
>> Each segment in the /home/postgres/archive/master/ is 16MB each
>> There are currently 47443 files in this folder.
>>
>> If I want to limit the total size use by WAL archive to around 200-400
>> GB, what value should I set for the wal_keep_segments,
>> checkpoint_segments?
>
> PostgreSQL doesn't clean up files copied by your archive_command. You need to
> have a separate task clean those out. PostgreSQL's active wal_keep_segments
> etc. are in the data/pg_xlog directory.
>

The OP might want to take a look at:

http://www.postgresql.org/docs/9.4/interactive/pgarchivecleanup.html

To be safe I would use:

-n

Print the names of the files that would have been removed on stdout
(performs a dry run).

at first.

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com