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

[Bo Peng]

hello,

On Wed, 1 Mar 2023 06:03:08 -0600
Ron <ronljohnsonjr at gmail.com> wrote:

> 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

I don't think watchdog is related to archive mode.
Could you show the documentaion?
 
> > If you enable archive mode, you need to remove old WAL files periodically after backup.
> 
> Using pg_archivecleanup?

Yes.

-- 
Bo Peng <pengbo at sraoss.co.jp>
SRA OSS LLC
https://www.sraoss.co.jp/