Hi,
I've set up hot standby slaves for a couple of clusters.The wal is cleaned up after use, i don't use it as a backup (yet).
It seems that the amount of wal peaks shortly after midnight, when pg_dump is running.It doesn't seem logical to me that pg_dump should generate wal, but i haven't been able to find a different explanation so far.
So to make sure, i want to ask you people: can it be that running pg_dump creates a lot of wal?
Cheers,
WBL
--
"Quality comes from focus and clarity of purpose" -- Mark Shuttleworth