Re: pg_start_backup() takes too long - Mailing list pgsql-general

From Joshua D. Drake
Subject Re: pg_start_backup() takes too long
Date
Msg-id 48DFA455.5050808@commandprompt.com
Whole thread Raw
In response to Re: pg_start_backup() takes too long  ("Ivan Zolotukhin" <ivan.zolotukhin@gmail.com>)
Responses Re: pg_start_backup() takes too long  (Simon Riggs <simon@2ndQuadrant.com>)
List 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 by date:

Previous
From: "Ivan Zolotukhin"
Date:
Subject: Re: pg_start_backup() takes too long
Next
From: Simon Riggs
Date:
Subject: Re: pg_start_backup() takes too long