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

[Paul Cunnane]

Thank you!

On Wed, Mar 1, 2023 at 1:52 AM Bo Peng <pengbo at sraoss.co.jp> 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.
>
> 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/
>


-- 

*Paul Cunnane* | CEO
Westnet Broadband Mayo Ltd t/a Westnet
Cedar House, Castlebar, Co. Mayo
Registered in Ireland no. 572580
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.pgpool.net/pipermail/pgpool-general/attachments/20230301/4de0de7e/attachment.htm>