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

Ron ronljohnsonjr at gmail.com
Wed Mar 1 21:03:08 JST 2023


On 2/28/23 19:52, Bo Peng wrote:
> 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.

Is this true when using watchdog in a cluster (which says that archive mode 
must be on)?

https://www.pgpool.net/docs/43/en/html/example-cluster.html

> If you enable archive mode, you need to remove old WAL files periodically after backup.

Using pg_archivecleanup?

-- 
Born in Arizona, moved to Babylonia.



More information about the pgpool-general mailing list