I have the 'archive_cleanup_command' command specified, but I still have WAL files.
The documentation seems to indicate that it will run automatically, but it doesn't seem to be running.
archive_cleanup_command = 'pg_archivecleanup \\\\DISKSTATION\\AccessData\\Prod\\WALfiles %r'
# command to execute at every restartpoint
It seems it should run every time there is a restartpoint.
Restartpoints can happen at any checkpoint in the log.
My checkpoint time out is set to 5 minutes.
checkpoint_timeout = 5min
Restartpoints are more likely to happen when getting closer to the size limit.
max_wal_size = 1GB
My folder size is now 430 files = 6.8 GB. Not terrible, but should be enough to trigger a restartpoint.
How do I tell if I haven't had a restartpoint or I did and the command didn't work.
No errors in the pg_log
Thanks,
Brad.