[pgpool-general: 8617] Re: Trying to understand $ARCHIVEDIR

Bo Peng pengbo at sraoss.co.jp
Wed Mar 1 10:52:45 JST 2023


Hello,

> Checking out increasing disk usage on my primary db server I noticed log
> archives were building up in ~postgres/archivedir. It's been a while since
> I set up my pgpool-II cluster so I had to do some digging to understand why
> the logs are being archived there, and it turns out it's because they're
> referenced in my follow_primary.sh (as copied from the sample script).
> 
> Assuming I'm happy with my backup strategy in general, is there a reason I
> need to keep these archived files? Do I need the archive_command at all?

It is not necessary to enable archive mode.
If you have your backup strategy or if you are using replication slot,
you can disable archive mode to save disk space.

If you enable archive mode, you need to remove old WAL files periodically after backup.
-- 
Bo Peng <pengbo at sraoss.co.jp>
SRA OSS LLC
https://www.sraoss.co.jp/


More information about the pgpool-general mailing list