From: | Brad White <b55white(at)gmail(dot)com> |
---|---|
To: | "pgsql-generallists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org> |
Subject: | WAL file clean up |
Date: | 2024-01-17 03:03:10 |
Message-ID: | CAA_1=92NqJcYDZ0Q4Q1fDrmdzpzBb5yNYSJ87+AqFLjeCnsMdw@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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.
From | Date | Subject | |
---|---|---|---|
Next Message | arun chirappurath | 2024-01-17 04:04:00 | Re: postgres sql assistance |
Previous Message | Brad White | 2024-01-17 01:41:58 | Re: replication not replicating |