[pgpool-general: 8188] Re: Cleanup of WAL archive

[Bo Peng]

Sorry for the late response.

> I have 3 postgresql servers in a cluster behind pgpool. I'm using streaming replication. I'm finding that the WAL archive directory on the primary server grows without bound. I would expect the WAL files to be removed once the 2 replicas have consumed the files. How are others handling this?
>
> Doing more reading on this and looking at the scripts that are used by pgpool, it's not clear to me that I need to be archiving WAL files. If I'm using streaming replication, then the backup should always be up to date and due to the pg_basebackup call in the follow_master.sh that should keep everything updated, correct? Or are the archived WAL files there to handle the time between when the current primary server hands off to the standby server? If so, how are the archived WAL files supposed to be cleaned up?

If you are using replication slot, you can disable "archive_mode". 
The sample scripts are just an example to help you easily setup a cluster. 
They may need to be customized to meet your specific requirements.

If you wish to enable "archive_mode", you should periodically delete the old WALs.

> From: pgpool-general <pgpool-general-bounces at pgpool.net> on behalf of Jon SCHEWE <jon.schewe at raytheon.com>
> Sent: Friday, May 13, 2022 11:42
> To: pgpool-general at pgpool.net <pgpool-general at pgpool.net>
> Subject: [External] [pgpool-general: 8158] Cleanup of WAL archive 
>  
> I have 3 postgresql servers in a cluster behind pgpool. I'm using streaming replication. I'm finding that the WAL archive directory on the primary server grows without bound. I would expect the WAL files to be removed once the 2 replicas have consumed the files. How are others handling this?
> 
> Jon Schewe
> Principal Software Systems Technologist
> 
> C: +1 612.263.2718
> O: +1 952.545.5720
> jon.schewe at raytheon.com
> 
> Raytheon BBN
> Raytheon Intelligence & Space
> 5775 Wayzata Blvd. Suite 630
> St. Louis Park, MN 55416 
> 
> RTX.com | LinkedIn | Twitter | Instagram 
> _______________________________________________
> pgpool-general mailing list
> pgpool-general at pgpool.net
> http://www.pgpool.net/mailman/listinfo/pgpool-general


-- 
Bo Peng <pengbo at sraoss.co.jp>
SRA OSS, Inc. Japan
http://www.sraoss.co.jp/