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

Bo Peng pengbo at sraoss.co.jp
Fri Mar 3 16:46:48 JST 2023


Hello,

> > 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 want to do PITR, I recommend enabling archive mode.

On Wed, 1 Mar 2023 09:55:39 +0000
Paul Cunnane <paul.cunnane at westnet.ie> wrote:

> 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


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



More information about the pgpool-general mailing list