[pgpool-general: 3959] Re: Archive Cleanup

Tatsuo Ishii ishii at postgresql.org
Thu Aug 13 17:35:42 JST 2015

> 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

More information about the pgpool-general mailing list