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

From Ivan Zolotukhin
Subject Re: pg_start_backup() takes too long
Date
Msg-id 751e56400809280827v6dd2ac81t3a8e5581fd3404d0@mail.gmail.com
Whole thread Raw
In response to Re: pg_start_backup() takes too long  (Bruce Momjian <bruce@momjian.us>)
Responses Re: pg_start_backup() takes too long  ("Joshua D. Drake" <jd@commandprompt.com>)
List pgsql-general
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.

Regards,
 Ivan

On Tue, Sep 23, 2008 at 6:18 AM, Bruce Momjian <bruce@momjian.us> wrote:
> Ivan Zolotukhin wrote:
>> Hello,
>>
>> What is the reason for
>>
>> select pg_start_backup('label');
>>
>> taking 10 minutes on not so loaded system even right after manual checkpoint?
>
> No idea;  something is seriously wrong if that is happening.  Do the
> database server logs or kernel logs show anything unusual?
>
> --
>  Bruce Momjian  <bruce@momjian.us>        http://momjian.us
>  EnterpriseDB                             http://enterprisedb.com
>
>  + If your life is a hard drive, Christ can be your backup. +
>

pgsql-general by date:

Previous
From: "Abraham, Danny"
Date:
Subject: Can anyone explain?
Next
From: "Joshua D. Drake"
Date:
Subject: Re: pg_start_backup() takes too long