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.klaver@xxxxxxxxxxx
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
