wal archive peak during pg_dump

Поиск
Список
Период
Сортировка
От Willy-Bas Loos
Тема wal archive peak during pg_dump
Дата
Msg-id CAHnozTgho9v5enU0Cop2rY5jmg-LXYDviqVLtdbJGo4p2R7eng@mail.gmail.com
обсуждение исходный текст
Список pgsql-general

please excuse my forgetting [GENERAL] in the subject of the other mail.

On Thu, Jan 9, 2014 at 11:42 AM, Willy-Bas Loos <willybas@gmail.com> wrote:
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



--
"Quality comes from focus and clarity of purpose" -- Mark Shuttleworth

В списке pgsql-general по дате отправления:

Предыдущее
От: Willy-Bas Loos
Дата:
Сообщение: wal archive peak during pg_dump
Следующее
От: Marco Baringer
Дата:
Сообщение: getting domain information from query results