[pgpool-general: 3959] Re: Archive Cleanup

[Tatsuo Ishii]

> Hi everyone.
> 
> We have a successful PGPoolII installation running nicely using streaming
> replication.
> 
> However we're trying to work out what we need to keep in our WAL archives -
> as these are filling up quickly.
> 
> Do we need to run a manual base_backup regularly and clean up anything
> prior to that in the Wal archive folder?

I think you can use pg_archivecleanup instead.

> Or based on the fact that PGPool
> runs a base_backup during a resync when required - that in fact we don't
> need any of the wal archives?

Wal archives are neccessary when the standby is largely behind and wal
segments required by the standy are gone on the primary server.

If you are using PostgreSQL 9.4 or later, you could use replication
slots instead of wal archives though.

Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp