Re: pg_start_backup() takes too long

Поиск
Список
Период
Сортировка
От Joshua D. Drake
Тема Re: pg_start_backup() takes too long
Дата
Msg-id 48DFA455.5050808@commandprompt.com
обсуждение исходный текст
Ответ на Re: pg_start_backup() takes too long  ("Ivan Zolotukhin" <ivan.zolotukhin@gmail.com>)
Ответы Re: pg_start_backup() takes too long  (Simon Riggs <simon@2ndQuadrant.com>)
Список pgsql-general
Ivan Zolotukhin wrote:
> Hello,
>
> Nothing bad both in system and postgres logs :( No serious activity
> during backup. I've had to change statement_timeout for backup user to
> make it work. But I cannot reproduce this case unfortunately.

This is actually not uncommon and PostgreSQL shows exactly nothing in
terms of why it is taking so long. The only assumption I have come up
with is that start_backup does cause a checkpoint.

Sincerely,

Joshua D. Drake

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

Предыдущее
От: "Ivan Zolotukhin"
Дата:
Сообщение: Re: pg_start_backup() takes too long
Следующее
От: Simon Riggs
Дата:
Сообщение: Re: pg_start_backup() takes too long