pg_archivecleanup issues

From: Jorge Torralba <jorge(dot)torralba(at)gmail(dot)com>
To: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: pg_archivecleanup issues
Date: 2013-12-05 17:14:29
Message-ID: CACut7uSg9c4f-XijZ=XbnYB=vWTYDBfFiVE4UWRSTMqxZSMZ=A@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

We have an issue with pg_archivecleanup and was wondering if anyone is
experiencing the same.

We use pg_archivecleanup to clean up old wal files prior to the last base
backup. However, if we have a lot of old wal files, it will only delete a
few even though it echos the statement pg_archivecleanup: removing file
"/opt/dbbackups/db1_wal_keep//000000010000013D00000079"

After all is said and done, we have to run pg_archivecleanup several times
in order to clean up all the old wal files. It just does not take care of
them all with one execution.

On a side note, these WAL files reside on an NFS share.

Just curious if anyone is experiencing the same.
--
Thanks,

Jorge Torralba
----------------------------

Note: This communication may contain privileged or other confidential
information. If you are not the intended recipient, please do not print,
copy, retransmit, disseminate or otherwise use the information. Please
indicate to the sender that you have received this email in error and
delete the copy you received. Thank You.

Browse pgsql-admin by date

  From Date Subject
Next Message Boris Bukowski 2013-12-06 10:05:53 Base Backups to a remote location
Previous Message Simon Riggs 2013-12-03 09:12:43 Re: MultiXactId Error in Autovacuum