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

[Jon SCHEWE]

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?

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