Postgres Pro
Downloads
Home   >   mailing lists

wal archive peak during pg_dump - Mailing list pgsql-general

From Willy-Bas Loos
Subject wal archive peak during pg_dump
Date
Msg-id CAHnozTh7cLteg4RCmW_tpWroTVBmym5DdrA5H1P1KQNwbEFS9g@mail.gmail.com
Whole thread Raw
Responses Re: wal archive peak during pg_dump  (Michael Paquier <michael.paquier@gmail.com>)
Re: wal archive peak during pg_dump  (Luca Ferrari <fluca1978@infinito.it>)
List pgsql-general
Tree view
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

pgsql-general by date:

Previous
From: Francisco Olarte
Date:
Subject: Re: Last inserted row id with complex PK
Next
From: Willy-Bas Loos
Date:
Subject: wal archive peak during pg_dump