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
This email may contain confidential, privileged or copyright material and is solely for the use of the intended recipient(s).
Вложения
В списке pgsql-novice по дате отправления: