wal archive peak during pg_dump - Mailing list pgsql-general

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