Hi all,
I've noticed that my standby servers never bother to delete a wal backup file from the archiving directory. In fact,
theynever even try to copy it out of the directory, and after
a while, I may see over a dozen files like:
000000040000000A000000F9.backup
000000040000000C00000003.backup
etc.
The youngest of these files is from last Friday afternoon, and these rest go back over 6 weeks. Being this is a
streamingreplication standby, I probably don't need them at all,
but I've been keeping them as insurance policies. Question is how many, if any, do I need to keep?
--
Jay