Re: archive_cleanup_command when is called?

> I am setting up a PostgreSQL (9.3) standby server in Streaming replication.
> I configured the recovery.conf file and everything working well a part of
> the archive_cleanup_command.
>
> If you don't need PITR, avoid archive shipping. Streaming is recommended
[#personalOpinion].

> The WAL files shipped from the master to the temporary folder with the
> archive_command are correctly saved, but are never deleted from the slave
> server.
>
> How are you shipping the WAL from master to temporary location? your
archive_command on Master is set to use rsync or scp or ftp to ship wal
files?

> archive_cleanup_command = 'pg_archivecleanup /mnt/db1/incoming %r'
>

I think there could be some permission issues. Can you try to redirect the
result to a log?
'pg_archivecleanup -d /mnt/standby/archive %r 2>>cleanup.log'

Best Regards,
*Sameer Kumar | Database Consultant*

*ASHNIK PTE. LTD. *101 Cecil Street, #11-11 Tong Eng Building, Singapore
069533
M : *+65 8110 0350* T: +65 6438 3504 | www.ashnik.com
www.facebook.com/ashnikbiz | www.twitter.com/ashnikbiz

[image: email patch]

This email may contain confidential, privileged or copyright material and
is solely for the use of the intended recipient(s).