Sunday, September 28, 2008

Re: [GENERAL] pg_start_backup() takes too long

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.


Joshua D. Drake

Sent via pgsql-general mailing list (
To make changes to your subscription:

No comments: